Difference between primary key and unique key ?
Answer Posted / niranjan dhungia
Primary key doesnot allow null value but unique key allows
null value. We can declare only one primary key in a table
but a table can have multiple unique key(column assign).
Is This Answer Correct ? | 1017 Yes | 126 No |
Post New Answer View All Answers
What is the scope of a local variable?
What is Reduced List of Values?
How index is implemented in oracle database?
What happens to the current transaction if a ddl statement is executed?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
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.
How to get maxsal , minsal, ename department wise in single query
How to turn on or off recycle bin for the session?
what is a Nested Loop join?
What is the difference between Delete, Truncate and Drop in Oracle?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Why does Oracle not permit the use of PCTUSED with indexes?
What is a tns file?
What is bulk copy or bcp in oracle?
Explain the use of grant option in exp command.