Difference between primary key and unique key ?
Answer Posted / praveen
primary key not allows null values, but unique key allows null values. only one primary is possible in one table, but multiple unique keys are possible in a table. Each unique key accepts only one null field. Both are used to prevent repeated entry of values.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is bind variable in oracle 11g?
Point the difference between translate and replace?
What are the arithmetic operations?
What is where clause in oracle?
How view is different from a table?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Explain the use of tables option in exp command.
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How do I find the database name in oracle?
Difference between open_form and call_form in oracle.
How to do a full database export?
What are the ansi data types supported in oracle?
What are the restrictions on external table columns?
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
How to bring a tablespace offline?