what is primary key and foreign key when and where have to use
Answer Posted / prashant
primary key has a unique & it is only one in a
databasewhile fkey is not unique. it is based on primary key
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to end the current transaction in oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
State the difference between a primary key and foreign key?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
How to create a new tablespace in oracle?
Can we call procedure inside function in oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to rollback the current transaction in oracle?
how may join possible between (requisition with purchase order)
Differentiate between function and procedure in oracle.
What is hash cluster in oracle?
How to install oracle odbc drivers?
How to load excel data sheet to oracle database
What is a snapshot log?
What is oracle server autotrace in oracle?