Difference between primary key and unique key ?
Answer Posted / praveen
primary key not allows null values, but unique key allows null values. only one primary is possible in one table, but multiple unique keys are possible in a table. Each unique key accepts only one null field. Both are used to prevent repeated entry of values.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is catalog in Oracle?
how may join possible between (requisition with purchase order)
How to load excel data sheet to oracle database
How many categories of data types?
Explain user account with reference to oracle.
Explain what are the characteristics of data files?
What are the components of logical database structure in oracle database?
Why should I use oracle database?
How to create a table index in oracle?
Where do we use decode and case statements?
How to loop through a cursor variable?
Can a parameter be passed to a cursor?
How to get execution statistics reports on query statements?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
How to compare dates in oracle sql?