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
What is an oracle?
Explain a private synonyms?
What is oracle database client?
Design database draw er diagram for a certain scenario ?
What is hot backup and logical backup?
What is proxy method?
What is the disadvantage of User defind function?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
Can a formula column be obtained through a select statement ?
How do I reset a sequence in oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
Why oracle is used?
What are the types of partitions in oracle?
How to create a new oracle data file?
What is transaction control statement and how many types of transaction control statement in Oracle?