Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between primary key and unique key ?
- 77 Answers
- 210056 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 / mareeswaran-jeyakani
The primary key cannot be accept the null values.The unique key can accept null values. assume that you have a two
columns column1 having primary key constraint and column2 having unique constraint if u try to insert null into column2 it will accept that values whereas column1 will not accept the null values.
THANK YOU.ALL THE BEST...............
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
How to put more than 1000 values into an oracle in clause?
What is the difference between primary key and unique key and foreign key in oracle?
What is the meaning of recursive hints in oracle?
How to call a stored function in oracle?
How to use like conditions in oracle?
ABOUT IDENTITY?
How to create a new tablespace in oracle?
Is primary key indexed by default in oracle?
How can I get column names from a table in oracle?
How to synchronize 2 schema's objects?
How to filter out duplications in the returning rows using oracle?
How many types of synonyms in Oracle?
Explain enable novalidate constraint.
what is normalisation?what are its uses?
