Difference between primary key and unique key ?
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 delete a column in an existing table?
How to estimate disk space needed for an export job?
What is materialized view in Oracle?
How to use like conditions in oracle?
What is the parameter mode that can be passed to a procedure?
What is the usage of merge statement?
How to load a large xml file?
What is control file used for?
What is the data pump export utility?
What is set verify off in oracle?
What operating systems are supported by oracle database 10g xe?
Explain self joins in oracle?
How to apply filtering criteria at group level in oracle?
What types of joins are used in writing subqueries?
What is a tns file?