Difference between primary key and unique key ?
- 77 Answers
- 198318 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
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
Give syntax for SQL and ORACLE joins.
Explain an index segment?
How to save query output to a local file?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How to set up autotrace for a user account?
what is the scenario where you take the database to NoArchivelog mode?
Point out the difference between user tables and data dictionary?
How to start an oracle instance?
What are data pump export and import modes?
What is the difference between primary key and unique key and foreign key in oracle?
What is system tablespace?
How to create a stored procedure in oracle?
what happened to the global index when I truncate the data in one of the partition?
IS it possible to built the oracle database without setting the kernal parameters?
What is the data type of dual table?
