Difference between primary key and unique key ?
Answer Posted / satya
Primery Key = (Unique key - NULL values)
One table may have more than one Unique Key Constraint
columns, but should have only one Primary Key Constraint
column.
Any comment? please shoot a mail.
| Is This Answer Correct ? | 329 Yes | 90 No |
Post New Answer View All Answers
How to start your 10g xe server from command line?
How to get last row id?
what are the advantages of running a database in archive log mode?
Please explain compound trigger in oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What is ADDM Advisor in Oracle?
What are the advantages of oracle 12c?
Explain about achiever in sql?
How to store only time; not date and time?
Explain the use of ignore option in imp command.
How many memory layers are in the oracle shared pool?
How do you find current date and time in oracle?
What is Undo Management Advisor in Oracle?
How to connect the oracle server as sysdba?
What is the difference between substr and instr?