Difference between primary key and unique key ?
Answer Posted / sikander
Primary key does not allow null value but unique key allows
null value. suppose tableA two column : columnB & columnC .
where coulmnB is primary key & columnC is unique key.
If we insert null value in columnB.It will not accept
columnB but columnC
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are temporal data types in oracle?
What is oracle rowcount?
Which is better Oracle or MS SQL? Why?
What is a static data dictionary in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Can multiple cursors being opened at the same time?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
Why should I use oracle database?
Explain implicit cursor.
Can objects of the same schema reside in different tablespace?
How do I learn what codesets are available in oracle?
How to omit columns with default values in insert statement in oracle?
How to call a sub procedure?
How to convert csv to table in oracle?
Explain rename?