Difference between primary key and unique key ?
Answer Posted / susil kumar rout
When we applied primary key constraint upon a column of a table internally oracle create a cluster index.In case of unique constraint,oracle create a non-cluster index.
In a table or entity one primary key and one or more than one
unique key can be applied.
We can't insert duplicate value or null value to primary key
column where as null value can insert into unique key column.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the use of show option in imp command.
How to load a large xml file?
What is a read only transaction in oracle?
What is data file?
How many types of auditing in Oracle?
What is MTTR advisor in Oracle?
State the various uses of dbcc command?
what is IDE,DMV in sql server?
What is rowid and rownum in oracle?
Why is oracle used?
How to define an anonymous block?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is the database name in oracle?
What is a dead lock in oracle?
How to connect asp pages to oracle servers?