What is difference between UNIQUE constraint and PRIMARY KEY
constraint ?
Answer Posted / kiran
if unique then it can have null
but if column has primary then it cannot have null values
and duplicate values
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How do we display rows from the table without duplicates?
State and explain the different types of data models?
What is the quickest way to fetch the data from a table?
How to insert a record into a table?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
How to create lov dynamically at runtime & attach to text field?
Explain about achiever in sql?
Explain the use of control file?
How to use "if" statements on multiple conditions?
What is a procedure in oracle?
How do we get field detail of a table?
What are data pump export and import modes?
What are the differences between lov and list item?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
Explain the difference between a procedure and a function? What do you understand by those terms?