Difference between primary key and unique key ?
Answer Posted / jason james john
unique key is a key that uniquely defines the characteristics of each row whereas primary key consists of characteristics that cannot collectively be duplicated by any other row.primary key will not allow null values whereas unique key will allow nulls.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we insert data in view oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What is the sid in oracle?
How to save query output to a local file?
Respected sir, Please send me technical questions related to oracle apps..
What happens if the imported table already exists?
What is sequence?
How to rename a column in an existing table?
is there a tool to trace queries, like profiler for sql server?
What is recycle bin in Oracle?
How to define an anonymous procedure without variables?
11. Display the client number and name and the client number and name of the person who referred that client.
Difference between inner join vs where ?
What do you mean by merge in oracle and how can you merge two tables?
What is a user account in oracle?