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 language is oracle sql developer?

1071

---

How do you rename a table in sql?

1186

---

What are the different datatypes available in PL/SQL?

1147

---

Why do we need view in sql?

1039

---

What are the different types of dbmss?

1055

---

how to fetch alternate records from a table? : Sql dba

1166

---

Show the cursor attributes of pl/sql.

1101

---

Is sql between inclusive?

1199

---

How do I run a query in pl sql developer?

1051

---

What does (+) mean in sql joins?

1120

---

How do I count records in sql?

1053

---

What is sql key?

1045

---

Where is pl sql used?

1005

---

What program will open a mdb file?

1020

---

Is vs as in pl sql?

1037

---