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

How is use pl and sql?

1059

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

970

---

how would you get the current date in mysql? : Sql dba

967

---

what are the advantages a stored procedure? : Sql dba

976

---

What is the primary use of normalization?

1002

---

What is composite primary key in sql?

996

---

What are reports usually used for?

1023

---

What is a procedure in pl sql?

1208

---

What are the events on which a database trigger can be based?

1185

---

How do I find duplicates in the same column?

1082

---

Explain the the update statement in sql?

1036

---

Why stored procedures are faster than query?

1023

---

How run sql*plus commands that are stored in a local file?

1061

---

What is right join in sql?

1089

---

Why stored procedure is better than query?

946

---