Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 208178 Views
- Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions, I also Faced
- E-Mail Answers
Answer Posted / anuradha
The unique column constraints permits multiple entries of
null in the column. these null values are clubbed at top of
column in order they were entered into table. this is
essential difference .
Table have more than 1 unique key which is not possible in
primary key
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is system tablespace?
What is proxy method?
Can you have more than one content canvas view attached with a window ?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
How many types of segments in Oracle?
What is sequence?
Explain the use of consistent option in exp command.
How to assign a tablespace to a users in oracle?
How to write numeric literals in oracle?
What is a nested table?
What are the uses of synonyms?
How to loop through data rows in the implicit cursor?
What is an oracle and why it is used?
How to get a list of all user accounts in the database?
What happens to the current transaction if the session is ended?
