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
11. Display the client number and name and the client number and name of the person who referred that client.
Why do you use stored procedures and state some of its disadvantages?
what is reindexing?
What happens to the data files if a tablespace is dropped?
How to retrieve the count of updated rows?
Explain the use of compress option in exp command.
How to drop a stored procedure in oracle?
How to drop an existing table in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to use group functions in the select clause using oracle?
Explain database link?
Is java required for oracle client?
What is a trigger and what are its types in oracle?
What are the differences between interval year to month and interval day to second?
How to generate query output in html format?