Difference between primary key and unique key ?
Answer Posted / rakesh dwivedi
1.Primary key can not have null.Instead of it unique can have null at lest single time null.
2 In a table only one primary key exist.Unique can be multiple in table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What happens if the imported table already exists?
Difference between open_form and call_form in oracle.
How to define an anonymous block?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is translate in oracle?
How does one get the view definition of fixed views/tables?
Explain what does a control file contain?
What are the extensions used by oracle reports?
What is Trigger in Oracle?
What are the differences between primary key and unique key?
When do you get a .pll extension in oracle?
What are the uses of a database trigger?
What are the various constraints used in oracle?
How to load data through external tables?
How to rename an existing table?