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
Where do we use decode and case statements?
Explain the use of indexes option in exp command.
How to use "in out" parameter properly?
What are the types of partitions in oracle?
Explain do view contain data?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Compare and contrast between sql and sql server and explain its various functions?
How many file formats are supported to export data?
What is the parameter mode that can be passed to a procedure?
How to use attributes of the implicit cursor in oracle?
How to select all columns of all rows from a table in oracle?
How to check the oracle tns settings?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
How many types of table in Oracle?
How to open a cursor variable?