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 is before trigger?

999

---

What is difference between mysql and postgresql?

1143

---

Can we perform dml on view?

1040

---

What is record variable?

980

---

How do I copy a table in sql?

979

---

what is 'mysqlcheck'? : Sql dba

1011

---

How do you create an update query?

957

---

What are the two parts of design view?

1014

---

What is a full join?

967

---

What is the difference between clustered and non-clustered index in sql?

1011

---

What is partition by in sql?

1061

---

List out the acid properties and explain?

949

---

Is big data nosql?

939

---

What is snowflake sql?

1069

---

What is a pragma statement?

1262

---