Difference between primary key and unique key ?
Answer Posted / avesh upadhyay,iims
are yar
primary key that does not accept null value
and in table only one exist.
but the case of uniue key that accept null value one or more
and many unique key exist in a single table
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Where do you use decode and case statements?
What are named parameters?
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?
How to delete all rows a table in oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What are the oracle differences between nvl and coalesce
What is a cursor variable?
How to pass parameters to procedures in oracle?
How to create a new table by selecting rows from another table?
How to convert csv to table in oracle?
How to create an initialization parameter file?
Whether any commands are used for months calculation? If so, what are they?
How do I reset a sequence in oracle?
What is oracle in java?
How do I use os authentication with weblogic jdriver for oracle and connection pools?