Difference between primary key and unique key ?
- 77 Answers
- 197768 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 / praveen
primary key not allows null values, but unique key allows null values. only one primary is possible in one table, but multiple unique keys are possible in a table. Each unique key accepts only one null field. Both are used to prevent repeated entry of values.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain joins in oracle?
How to define a sub function?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
Explain compound trigger in oracle?
What are the oracle built-in data types?
Can you tell me how to add new column in existing views?how?How is possible?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
How do I spool to a csv formatted file using sqlplus?
How to define an explicit cursor in oracle?
How to do clean up if create database failed?
What is SQL Tuning Advisor in Oracle?
How to open a cursor variable?
What is ordinary table in oracle?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is oracle data type?
