Difference between primary key and unique key ?
Answer Posted / satendra dixit
Primary Key
1. Not Null
2. One primary key can be defined at on table
Unique Key
1. May be Null
2. one or more then 1, can be implemented
| Is This Answer Correct ? | 22 Yes | 11 No |
Post New Answer View All Answers
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How to assign a table row to a record variable?
Are truncate and delete commands same? If so why?
How to delete multiple rows from a table in oracle?
How to retrieve data from an explicit cursor?
Explain view?
WHAT IS ecc 6.0
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
How to turn on or off recycle bin for the session?
How to check the oracle tns settings?
Which is better Oracle or MS SQL? Why?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to get the Installed Oracle Version Information ?
Explain about integrity constraint?
How to rename an index in oracle?