Difference between primary key and unique key ?

Answer Posted / suman chatterjee.

uniqe key may contain null values but primary key can not take the null values.

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to write date and time interval literals in oracle?

586


How would you change old and new values in an insert, delete and update triggers?

549


What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

551


How to define a data source name (dsn) in odbc manager?

540


What is the use of oracle?

564






What are the types of trigger in oracle?

581


How to define a cusotmer as a supplier in ORACLE R12

1730


Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

944


What to do if the binary spfile is wrong for the default instance?

571


What is rowid and rownum in oracle?

547


What is oracle host variable?

540


What is an oracle database?

616


Why does for update in oracle 8 cause an ora-01002 error?

559


why dont we assign not null constraint as table level constraint.

2261


What is a view and how is it different from a table?

578