Difference between primary key and unique key ?
Answer Posted / shakeel shikari
the difference is only primary key does not accept null values
while unique key accept null value
remember that unique key holds null only once
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create a table index?
What is an oracle function?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Give the various exception types.
What are the data types in oracle?
Why do we need integrity constraints in a database?
What is format trigger?
How to display row numbers with the records?
What to do if the startbd.bat failed to start the xe instance?
How much memory your 10g xe server is using?
How to create a temporary table in oracle?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
Differentiate between translate and replace?
When system tablespace is created?
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?