Can we use more than one null value for unique key?
Answer Posted / ashwin
you can insert as many values as u want, in uniquelly
declared column
some people r saying that if u insert more than one null
value in unique column of relation then null is duplicated
which violets unique key property..........well this saying
is totally rubbish......are pehle insert karke dekho phir
bolo as simple as that...
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Can we insert in view in sql?
what is the command used to fetch first 5 characters of the string? : Sql dba
How to install oracle sql developer?
What are the two characteristics of a primary key?
Differentiate between sga and pga.
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
what is bdb (berkeleydb)? : Sql dba
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...
Can one improve the performance of sql*loader? : aql loader
What are the different dcl commands in sql?
What is dba in sql? : SQL DBA
What is dialect in sql?
Why triggers are used?
What is sql key?
What has stored procedures in sql?