Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210511 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
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
What is the usage of merge statement?
Is a rollback possible to any savepoint?
What is bulk collect in oracle?
Give syntax for SQL and ORACLE joins.
What is rich query?
How to recover a dropped table in oracle?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How do you bind variables in oracle?
How to add a new column to an existing table with a default value?
How do I know if oracle is installed on windows?
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 is an oracle wallet?
What is truncate oracle?
How to open a cursor variable?
What is a proxy object?
