Interested to Buy Any Domain ? << Click Here >> for more details...
what are the advantages of primary key over unique+notnull
- 7 Answers
- 21987 Views
- Consultancy, LGS, Oracle, I also Faced
- E-Mail Answers
Answer Posted / shilpa.oracle
Primary key accepts only unique values and does not allow
null values.
Unique key accepts unique values and allows null values.
not null constraint allows duplicate values and doesnt allow
null values.
When a primary key constraint or unique key constraint is
created by default index is created on the columns with
these constraints.
| Is This Answer Correct ? | 16 Yes | 4 No |
Post New Answer View All Answers
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is query execution plan in sql?
What do you know by pl/sql cursors?
What is the starting oracle error number? What is meant by forward declaration in functions?
What operating systems are supported by oracle sql developer?
how to start mysql server? : Sql dba
What is the best partition size for windows 10?
How many parts of a pl sql block are optional?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
Can you do multiple joins in sql?
Why commit is not used in triggers?
what is sp_pkeys? : Transact sql
How do I trace sql profiler?
Explian rowid, rownum?
how to convert character strings to numeric values? : Sql dba
