Difference between primary key and unique key ?
Answer Posted / mareeswaran-jeyakani
The primary key cannot be accept the null values.The unique key can accept null values. assume that you have a two
columns column1 having primary key constraint and column2 having unique constraint if u try to insert null into column2 it will accept that values whereas column1 will not accept the null values.
THANK YOU.ALL THE BEST...............
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
how to make an oracle object
What is the difference between 10g OEM and 11g OEM?
How to create a table index in oracle?
How to revoke create session privilege from a user in oracle?
How to set a transaction to be read only in oracle?
What are the set operators union, union all, minus & intersect meant to do?
What is query image?
What is a user account in oracle?
What is rich query?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
How do I connect to oracle?
How to invoke the data pump import utility?
How does Oracle guarantee data integrity of data changes?
What is the difference between $oracle_base and $oracle_home?
Can you have more than one content canvas view attached with a window ?