Can we use more than one null value for unique key?
Answer Posted / christina
Yes, We can use more then one null value in unique key ,
because "null" means undefined or unknown so we can add any
number of null values in unique key...
This is the major difference between primary nd unique key,
Primary key doesn't allow null values to be entered into
the columns marked as priamry key and Unique allow us to
enter null values...............
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
How do I run a sql query?
What is serial sql?
Why schema is used in sql?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is execution plan in sql?
What does sql stand for?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What is full join in sql?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
How to call shell script from pl sql procedure?
What is pl sql in dbms?
What do you think about pl/sql?
What is index example?
Is a foreign key always unique?
How can we debug in PL/SQL?