what is the difference between primary key & foreign key?
Answer Posted / ibrahim
primay key uniquely identifies records in relation.
in a table only one primary key.But may have more than one
foreign key.
Is This Answer Correct ? | 14 Yes | 7 No |
Post New Answer View All Answers
How to upsert (update or insert into a table)?
What is the difference between Delete, Truncate and Drop in Oracle?
What is partitioned table in Oracle?
Point out the difference between user tables and data dictionary?
How to delete multiple rows from a table in oracle?
How many types of table in Oracle?
What is Redo Log Buffer in Oracle?
What are the advantages of oracle?
Why packages are used in oracle?
Why do we need oracle client?
Difference between inner join vs where ?
State some uses of redo log files?
How many anonymous blocks can be defined?
How would you go about verifying the network name that the local_listener is currently using?
> 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?