Difference between primary key and unique key ?
Answer Posted / kundn
Unique key Primary key
1. Can have null value 1. Can not have null value
2.Table can have multiple 2. Table Can have multiple unique
Unique keys keys
3Single column at a time 3. May be combination of one or
or more columns
| Is This Answer Correct ? | 14 Yes | 17 No |
Post New Answer View All Answers
What is analyze command used for?
How to delete a user account in oracle?
How can we delete duplicate rows in a table?
How do I reset a sequence in oracle?
What is an oracle user role?
What is the difference between truncate & delete command?
What are the various oracle database objects?
When do you get a .pll extension in oracle? Explain its importance
How to create id with auto_increment on oracle?
What is ASM (Automatic Storage Management) in Oracle?
Explain constraining triggers.
What is oracle host variable?
How to fetch the row which has the max value for a column?
what is difference between sql plus and sql*plus? (not sql and sql plus).
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.