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 difference between sql and mysql?

1188

---

how to use case expression? : Sql dba

1076

---

Explain the uses of control file.

1098

---

what are different types of collation sensitivity? : Sql dba

1115

---

Is id a reserved word in sql?

1186

---

What is PL/SQL Records?

1252

---

Is there a 64 bit version of ssms?

997

---

Where is sql database stored?

1037

---

Can a key be both primary and foreign?

1053

---

What is varchar data type in sql?

1136

---

explain commit and rollback in mysql : sql dba

1071

---

What are the various levels of constraints?

1167

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1052

---

What is a sql profiler?

1063

---

Define tables and fields in a database

1176

---