what is the difference between primary key & foreign key?
Answer Posted / suraj menon
primary key is used to identify a row and it doesnot allow
null values. It avoids duplication of rows.
Foreign key will allow "Null values" and "Duplicte values"
and it refers to a primary key in anoter table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why should I use oracle database?
What happens if you use a wrong connect identifier?
What are the different editions of oracle?
Why do you create or replace procedures rather that drop and recreate.
Is insert autocommit in oracle?
ABOUT IDENTITY?
What is the relationship among database, tablespace and data file?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
if you ctreate table identity
Explain the use of owner option in exp command.
What happens to the current transaction if the session is ended?
What is bind variable in oracle 11g?
What is a subquery?
What is a schema in oracle?