Difference between primary key and unique key ?
Answer Posted / austin johnson
we can't insert a NULL value into to coloumn holding
primary key constrain.
where as we can insert a NULL value to a unique key feild.
Remember, both keys are used to identify the
rows/tuple/entry of the table uniquely.
so, only once u can enter a NULL value into the unique key
feild.
| Is This Answer Correct ? | 146 Yes | 57 No |
Post New Answer View All Answers
How do I know if oracle is installed on windows?
What do you understand by a database object?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
List out the difference between commit, rollback, and savepoint?
Can we write dml statement in function in oracle?
What to do if the binary spfile is wrong for the default instance?
How to use an explicit cursor without open statements?
How can I see all tables in oracle?
What are group functions in oracle?
How to create additional tablespaces for an new database?
How do I find my oracle client driver version?
What is oracle analytical function?
Explain rename?
How to use values from other tables in update statements using oracle?
How to check the server version in oracle?