Difference between primary key and unique key ?
Answer Posted / umapathy.r
The column holding the primary key constraint cannot accept
null values.whereas colum holding the unique constraint can
accept null values assume that t3 is a table with two
columns t1 having primary key constraint and t2 having
unique constraint if u try to insert null into t2 it will
accept that values whereas column t1 will not accept null
Is This Answer Correct ? | 1164 Yes | 121 No |
Post New Answer View All Answers
How to write text literals in oracle?
How to synchronize 2 schema's objects?
Can we store images in oracle database?
Can the query output be sorted by multiple columns in oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
Differentiate between function and procedure in oracle.
What is the usage of merge statement?
How to get a list of all background sessions in the database?
How many data types are supported?
What is a cursor in oracle?
Write a trigger example in oracle?
Is rowid unique in oracle?
Briefly explain what is literal? Give an example where it can be used?
How to write an inner join with the where clause in oracle?
How to load a large xml file?