Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 212349 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 / sikander
Primary key does not allow null value but unique key allows
null value. suppose tableA two column : columnB & columnC .
where coulmnB is primary key & columnC is unique key.
If we insert null value in columnB.It will not accept
columnB but columnC
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to lock and unlock a user account in oracle?
What is the usage of save points in oracle database?
Are truncate and delete commands same? If so why?
How can we delete duplicate rows in a table?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
Can we call procedure inside function in oracle?
What are the differences between char and nchar in oracle?
Is truncate autocommit in oracle?
What is a dynamic performance view in oracle?
What types of joins are used in writing subqueries?
What is the parameter mode that can be passed to a procedure?
how to clone 9i Database on to 10g Database.
What are the attributes that are found in a cursor?
How to list all tables in your schema?
How to change system global area (sga) in oracle?
