what is the difference between primary key & foreign key?
Answer Posted / gaurav , ashish ,preeti , main
Primary key is used to identify a row in a table and it
doesnot allow null values. It avoids duplication of rows.
whereas foreign key refers to a column or combination of
columns included in the defenition of referential integrity
| Is This Answer Correct ? | 57 Yes | 16 No |
Post New Answer View All Answers
How to import one table back from a dump file?
Why packages are used in oracle?
Can we insert data in view oracle?
What do you mean by a tablespace?
What happens to indexes if you drop a table?
What is the difference between view and materialized view in Oracle?
How to use null as conditions in oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Is java required for oracle client?
What is enter substitution variable in oracle?
How to assign values to data fields in record variables?
What are the differences between date and timestamp in oracle?
What is the difference between pre-select and pre-query?
How translate command is different from replace?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?