Difference between primary key and unique key ?
Answer Posted / prashant t.
First difference is that primary key doesn't accept null
values whereas unique accepts one or multiple.
second difference is that Clustered index is created on
Primary key constraint and non clustered unique indexes is
created on Unique key constraint.
| Is This Answer Correct ? | 320 Yes | 94 No |
Post New Answer View All Answers
Can select statements be used on views in oracle?
Explain integrity constraint?
How to delete a column in an existing table in oracle?
What is the difference between a primary key & a unique key?
What do you mean by cdb and pdb in oracle 12c?
How can I combine multiple rows into a comma-delimited list in oracle?
Where are the settings stored for each instance in oracle?
How to import one table back from a dump file?
Is rowid unique in oracle?
Briefly explain what is literal? Give an example where it can be used?
What is the maximum number of triggers that can be applied to a single table?
How to rename an index?
What are the numeric comparison operations?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What are the attributes of cursor?