Difference between primary key and unique key ?
Answer Posted / vijay
Primary key's main role is to make field as unique and
relates to other sub table. Whereas unique is role only to
keep unique value in that field.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is the implicit cursor in oracle?
How to convert csv to table in oracle?
How to initialize variables with default values?
What are the built-in functions used for sending Parameters to forms ?
What is Undo Management Advisor in Oracle?
What is rowid and rownum in oracle?
Explain oracle 12c new features for developers?
how to do daily transactions with out sql* loader control file regesterd in apps?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Difference between inner join vs where ?
How data locks are respected in oracle?
What do you mean by merge in oracle?
How do we create privileges in oracle?
Why does for update in oracle 8 cause an ora-01002 error?