Answer Posted / sabariesh thavamani

i worked out the coding in the above using oracle 9 i, but
i could not get the correct answer what he told.. try it

SQL> create table sab(name varchar2(10) unique);

Table created.

SQL> insert into sab values('&sab');
Enter value for sab: null
old 1: insert into sab values('&sab')
new 1: insert into sab values('null')

1 row created.

SQL> /
Enter value for sab: null
old 1: insert into sab values('&sab')
new 1: insert into sab values('null')
insert into sab values('null')
*
ERROR at line 1:
ORA-00001: unique constraint (LPUSER18.SYS_C0038068)
violated


SQL> /
Enter value for sab: sabari
old 1: insert into sab values('&sab')
new 1: insert into sab values('sabari')

1 row created.

SQL> /
Enter value for sab: null
old 1: insert into sab values('&sab')
new 1: insert into sab values('null')
insert into sab values('null')
*
ERROR at line 1:
ORA-00001: unique constraint (LPUSER18.SYS_C0038068)
violated


SQL> select * from sab
2 ;

NAME
----------
null
sabari
try it....

What is the use of partition by in sql?

996

---

What is nosql example?

1035

---

What is full join in sql?

992

---

How much does sql cost?

1007

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1063

---

How do I upgrade sql?

1002

---

What is over () in sql?

965

---

explain the difference between bool, tinyint and bit. : Sql dba

1002

---

How to run sql commands in sql*plus?

1183

---

what is union, minus and interact commands? : Sql dba

1186

---

What is a unique key?

1056

---

Can we join more than 2 tables in sql?

1022

---

How to write a query to show the details of a student from students table whose

1000

---

Explain aggregate functions are available there in sql?

1008

---

What is normalization sql?

1060

---