Difference between primary key and unique key ?

Answer Posted / himanshu porwal

Primary key does not allow null values whereas in UNIQUE constraint we can have 1 null value means for that column one null value is allowed.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to rename an index?

779


How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

2940


Who developed oracle & when?

735


What is set operator oracle?

701


How to create additional tablespaces for an new database?

762






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

2471


How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2131


How to define an external table with a text file?

789


Can we use bind variables in oracle stored procedure?

671


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??

1556


what is the use of system.effective.date variable in oracle?

859


What is Reduced List of Values?

1877


How can I see all tables in oracle?

716


How to delete all rows a table in oracle?

793


Which dictionary tables and/or views would you look at to diagnose a locking issue?

1665