Difference between primary key and unique key ?
- 77 Answers
- 190704 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 / pralhad
Each table having only one PRIMARY KEY.And my contain many
UNIQUE KEYS.
PRIMARY KEY is identity of each row. UNIQUE KEY also
identity of each row.
BOTH keys will not contain repeated value.
BUT UNIQUE KEY will contain NULL value but PRIMAY key will
not contain NULL value.
| Is This Answer Correct ? | 63 Yes | 47 No |
Post New Answer View All Answers
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What is the use of file param in imp command?
What is object data modeling?
What is parameterized cursor in oracle?
What is the difference between a primary key & a unique key?
How to create a stored program unit?
How to write a query with an inner join in oracle?
IS it possible to built the oracle database without setting the kernal parameters?
What happens to the data files if a tablespace is dropped?
What is concurrency in oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
How to calculate date and time differences in oracle?
How does oracle handle read consistency?
how to clone 9i Database on to 10g Database.
What is an oracle data file?
