Is primary key = unique key,not null?
If yes,please explain
IF No,please explain
Answer Posted / edara satish
More or less both the keys sounds same, but the major
diffrence is where unique will allow null values, because
each null treated as a diffrent value internally. Incase of
primary key it will not allow any repeated data and null
data.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
How to write a query with a right outer join in oracle?
Explain index?
Explain do view contain data?
What is the usage of synonyms?
How to view the data files in the current database?
how to do daily transactions with out sql* loader control file regesterd in apps?
Explain the use of show option in imp command.
Is it possible to insert comments into sql statements return in the data model editor ?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
Please explain oracle left join with an example?
How many anonymous blocks can be defined?
What are the differences between number and binary_float in oracle?
How to start your 10g xe server from command line?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How to update a table row with a record?