Difference between primary key and unique key ?
Answer Posted / ajoy
primary key and unique key both can be referenced to other
table as foreign key. please check this error message
ORA-02270: no matching unique or primary key for this
column-list
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
What is a nvl function?
Explain the use of grant option in exp command.
What is index-organized table in Oracle?
What is the Tune Query
How to call a stored function in oracle?
What are the major difference between truncate and delete?
What to do if the binary spfile is wrong for the default instance?
What happens to the current transaction if the session is ended?
What is SQL Tuning Advisor in Oracle?
what are bitmap indexes? How does they work?
Give the various rollback segment states.
What is bulk collect in oracle?
What is a named program unit?
Why packages are used in oracle?
How to get execution statistics reports on query statements?