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 rename a column in an existing table?
How to retrieve data from an explicit cursor?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What are the differences between char and varchar2 in oracle?
What are the attributes of cursor?
How to use "out" parameter properly?
What is a sub query? What are its various types?
How to connect asp pages to oracle servers?
What are the different windows events activated at runtime ?
State the various uses of dbcc command?
What is oracle update statement with inner join ?
How to create a single index for multiple columns?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
What are the benefits of ordbms?
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'));