What is difference between UNIQUE constraint and PRIMARY KEY
constraint ?
- 3 Answers
- 6013 Views
- I also Faced
- E-Mail Answers
Answer Posted / allin
The Primarykey Constraint= unique + Not Null constraints.
For the Unique the meaning it self it is telling unique
value. won't accept duplicate values.
Thanks & Regards,
RatnaRao
9833847339
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Is oracle an open source?
State and explain about oracle instance?
What is archive log in Oracle?
What is oracle join syntax?
How to change system global area (sga) in oracle?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
How to retrieve data from an cursor to a record?
How to define an external table with a text file?
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.
Explain the blob datatype?
Explain the difference between sql and oracle?
How to create a new table in your schema?
Explain the use of consistent option in exp command.
How to define a sub function?
How do I limit the number of rows returned by an oracle query after ordering?
