Difference between primary key and unique key ?
Answer Posted / chauhan rakesh botad
Primary key doesnot allow null value but unique key allows
null value. We can declare only one primary key in a table
but a table can have multiple unique key(column assign).
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the different types of record groups in oracle? Explain each of them
Explain the use of control file?
How to create a stored procedure in oracle?
how the indexes are stored in the Oracle Database?
What is parameterized cursor in oracle?
How to call a stored function in oracle?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
How to export your connection information to a file?
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
How to filter out duplications in the returning rows using oracle?
How to assign data of the deleted row to variables?
Where do you use decode and case statements?
How to convert characters to numbers in oracle?
What is the disadvantage of User defind function?