Can we use more than one null value for unique key?
Answer Posted / pratibha
u can insert multiple null values without ant error:
SQL> create table sab(name varchar2(10) unique);
Table created.
SQL> insert into sab values('&sab');
Enter value for sab:
old 1: insert into sab values('&sab')
new 1: insert into sab values('')
1 row created.
SQL> /
Enter value for sab:
old 1: insert into sab values('&sab')
new 1: insert into sab values('')
1 row created.
SQL> /
Enter value for sab:
old 1: insert into sab values('&sab')
new 1: insert into sab values('')
1 row created.
SQL> /
Enter value for sab:
old 1: insert into sab values('&sab')
new 1: insert into sab values('')
1 row created.
SQL> /
Enter value for sab:
old 1: insert into sab values('&sab')
new 1: insert into sab values('')
1 row created.
SQL> SQL> select count(*) from sab;
COUNT(*)
----------
5
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are all ddl commands?
What are the types of dbms?
What are sql commands?
How can use stored procedures in sql?
Is a foreign key always unique?
Why do we use joins?
What is the purpose of primary key?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What is dba in sql? : SQL DBA
what is query cache in mysql? : Sql dba
What does where 1 1 mean in sql?
What is sql character function?
What do you think about pl/sql?
What is crud diagram?
what are local and global variables and their differences? : Sql dba