Difference between primary key and unique key ?
Answer Posted / himanshu porwal
Primary key does not allow null values whereas in UNIQUE constraint we can have 1 null value means for that column one null value is allowed.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to filter out duplications in the returning rows using oracle?
How to shutdown your 10g xe server?
What is recycle bin in Oracle?
How to experiment a data lock in oracle?
What is the usage of merge statement?
What are the advantages of oracle 12c?
Is there a function to split a string in plsql?
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 can I get column names from a table in oracle?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to define an external table with a text file?
Does oracle charge for java?
How view is different from a table?
Explain the different normalization forms?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?