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

What are all ddl commands?

1014

---

What are the types of dbms?

920

---

What are sql commands?

935

---

How can use stored procedures in sql?

1079

---

Is a foreign key always unique?

883

---

Why do we use joins?

984

---

What is the purpose of primary key?

966

---

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

971

---

What is dba in sql? : SQL DBA

997

---

what is query cache in mysql? : Sql dba

991

---

What does where 1 1 mean in sql?

979

---

What is sql character function?

994

---

What do you think about pl/sql?

948

---

What is crud diagram?

878

---

what are local and global variables and their differences? : Sql dba

1009

---