what is the difference between primary key & foreign key?
- 57 Answers
- 122437 Views
- CTS, Infosys, La Multi, Sparsh, Wipro, I also Faced
- E-Mail Answers
Answer Posted / anil bharodiya
Primary key is field of the table that can be used to
uniquely identify records of the table
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Differentiate between post-database commit and post-form commit?
How many categories of data types in oracle?
What are the original export and import utilities?
What do you understand by database schema and what does it hold?
How to get a create statement for an existing table?
How to use subqueries with the in operator using oracle?
How to write a query with a right outer join in oracle?
Explain the use of constraints option in exp command.
How to change program global area (pga) in oracle?
Why is oracle so popular?
ABOUT IDENTITY?
What are the major difference between truncate and delete?
How can we find out the duplicate values in an oracle table?
How to invoke the data pump import utility?
> 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?
