Posts
 
Reputation
Joined
Last Seen
Ranked #437
Strength to Increase Rep
+6
Strength to Decrease Rep
-1
91% Quality Score
Upvotes Received
11
Posts with Upvotes
10
Upvoting Members
9
Downvotes Received
1
Posts with Downvotes
1
Downvoting Members
1
6 Commented Posts
~82.3K People Reached
Interests
writing books, traveling n Programming
Favorite Tags
Member Avatar for VenusCrystal

Hi, I have installed Oracle 11g (latest version 11.2.0.1.0) on my system. During the installation it didnt ask me to set username or any password. I'm unable to start sql plus because i dont have the username and password. Can anyone tell me what is the default username and password …

Member Avatar for Shiwam_1
0
65K
Member Avatar for garyrichard

I am having a table with nvarchar feild in which values are entered like 1 4 8 25 I want a sql query to find the missing sequence of number in the above series... Thanks in advance...

Member Avatar for Shivraj_1
0
616
Member Avatar for king03

hi guys can anyone explain to me what the codes in line 5 and 6 do? How does the WHERE works in those lines? Any explanation would be truly appreciated. Thanks in advance. SELECT LAST_NAME ||', '|| FIRST_NAME AS "NAME" FROM EMPLOYEES E, (SELECT JOB_ID, MAX(SALARY) SALARY FROM EMPLOYEES GROUP …

Member Avatar for BitBlt
0
121
Member Avatar for koros.komen

Hi Prows,am creating a farm produce monitoring system using mysql and php.The database contains several tables of different produces that have the similar fields.The admin is supposed to update each table with different values.How will these datas relate. For example,maize field has Product-id,produce-name,location,date,time and mobile number of the buyer.Each table …

Member Avatar for diafol
0
252
Member Avatar for dean.ong.14
Member Avatar for king03

suppose there are given tables that has particular attributes, and for example I need to find how many ordered a specific dish.. example: "How many fried chicken orders were made in 1 month?" How do I do the sql statement for this? Thanks for those who will help. :D

Member Avatar for seslie
0
73
Member Avatar for king03

hi guys I really need some help I don't quite understand the instructions in our homework, I uploaded it below for your reference. Please explain to me how to do the things required on the instructions, it's not clear to me at all. Thank you for those who will help. …

Member Avatar for seslie
0
207
Member Avatar for caierhui

i have two columnns start date : end date 01/01/2012:02/01/2012 02/01/2012:03/01/2012 03/01/2012:04/01/2012 how do i use the end date as my start date? the given data is only the end date.

Member Avatar for seslie
0
89
Member Avatar for jtodd

Hey guys! I am building a data base in SQL server and am hoping to get some advice on frontends. The database is going to log and report on employee productivity. We would like to be able to use the frontend's forms to enter date time and project info in …

Member Avatar for seslie
0
156
Member Avatar for akkbkht

how to assign roles to users in Database ? mean i have admin, applicant ? so how could i differentiate bw them ? HELP !!!

Member Avatar for HunainHafeez
0
309
Member Avatar for papadarl

I am having a problem with validation I dont understand what the w3 school is saying. Can anyone help

Member Avatar for lps
0
69
Member Avatar for rithish

hello iam using oracle 10g express edition actually iam not able to connect to sql plus if i enter the commands it shows an error mesaage as "not connected".so i tried another way of opening by connecting in oracle 10g go to database home page and entered my password and …

Member Avatar for seslie
0
232
Member Avatar for HunainHafeez

i have a database ,i want to make it accessible to 3 type of users(admin,applicant,official) with different permissions .... how can i resolve,what i modifications it gonna need like to table , relations etc

Member Avatar for HunainHafeez
0
93
Member Avatar for code739

hi guys i got some problem with this code error said that exact fetch row return more than expected rows CREATE OR REPLACE PROCEDURE "MAINTAIN_REQUESTSTATUS1" (emplevel IN NUMBER,eid IN NUMBER,depid IN NUMBER,teamid IN NUMBER) is lastreq number; seq number; stat NUMBER; tok varchar2(60); appr number; CURSOR c1 IS select empid …

Member Avatar for code739
0
173
Member Avatar for anthonyjpv

Hi! 1. Whats the difference between using these PL/SQL records? -Table Based -Cursor Based -Programmer Based 2. Whats the importance of using PL/SQL Table? 3. Whats the importance of using VARRAYS? 4. When to use these 3 RECORDS, TABLES, VARRAYS Thanks!

Member Avatar for seslie
0
119
Member Avatar for Sadun89

Im going to create database.there are few table in that db. I need to know what is the best ; add more column to table or use separate table rather than add more column

Member Avatar for JorgeM
0
180
Member Avatar for kahindi

Am looking for possible projects for undergraduate in computer science.

Member Avatar for amrita111
0
116
Member Avatar for pjdomingo

Subject: System Analysis problem... We have our project in Systems Analysis ang Design this semester, and our preliminary step is to conduct and interview to study the existing system of our prospect organization. I know we are about to focus the interview on the system, but, I REALLY DONT KNOW …

Member Avatar for pjdomingo
0
87
Member Avatar for DJWK

# Can You Program like McGee in NCIS # I was watching a NCIS rerun and started to wonder about McGee's superhuman programming skills. He sat down in front of a random computer in a suspects house, and yet again, within two to three seconds he hacked the system. This …

Member Avatar for MrUpsetter
0
253
Member Avatar for TheSomalilander

# Hello every bodyI'm new to database modeling, my teacher asked me to choose a government institution and design/model a database for it using ERD modeling. I need help on creating the business rule and identifying the entities, I can add attributes once I create the business rule. I choosed …

Member Avatar for seslie
0
156
Member Avatar for ganges

hi have a nice time, guys can you provide me a complete list of orcle queries (SQL / PLSQL)

Member Avatar for debasisdas
0
124
Member Avatar for seslie

Hi Daniwebers, Is there anyone familiar with sharepoint? My question is on validation of dates in sharepoint… If i have two date fields – start date(& time) and end date(&time). How do i validate these, so that a person cannot pick a time in between these? For example, if someone …

0
117
Member Avatar for bflack

Hello, can anybody help me here? I am using mysql database and xampp server. Now, I made the database using my laptop computer and I have to distribute the database with its records to another laptop computer. The problem is when I tried to transfer the database file to the …

Member Avatar for veedeoo
0
200
Member Avatar for sreelavanya
Member Avatar for mustaffa hasan
0
70
Member Avatar for london-G

I have started a database application just like an address book, however I would like to have the user to upload a picture that will show when the user click save. Any idea? Thanks alot

Member Avatar for seslie
0
129
Member Avatar for rhfh

Hi guys, I'll doing a car rental database with 4 tables. Below is my the data after normalization..Could you guys pls tells me is it correct? If it's wrong, what to amend? Thanks so much.. Customer {CustomerID, FirstName, LastName, Address, ContactNo, Email} Agent {AgentID, FirstName, LastName, ContactNo, Email, RentaLID(FK)} Vehicle …

Member Avatar for 1stDAN
0
3K
Member Avatar for sneha_07

can any one help me out i want to make an application using oracle . i want to know evrything from scratch. plzzz tel me i am so eager to make it[COLOR="Red"][/COLOR]

Member Avatar for seslie
-1
98
Member Avatar for monstercameron
Member Avatar for tekboi

Hi, I'm writing a database for a computer shop and need some examples to look at. (It's not for a real shop, just a little project of mine) Where Can I find some templates for Access Database templates for a business like this?

Member Avatar for seslie
0
366
Member Avatar for almoj4ever

Hey Guyz I have a SQL Database Assignment i've done the first two tasts out of 7 and i need some help with the rest i can pay 150$ for anyone can help me with it ASAP !!

Member Avatar for seslie
0
96