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 error ora-12154: tns:could not resolve the connect identifier specified?

1030

---

What is cold data?

910

---

Who is the owner of mysql database?

1008

---

What is the difference between the implicit and explicit cursors?

1003

---

How global cursor can be declare with dynamic trigger ?

2155

---

How does one load ebcdic data? : aql loader

1103

---

Does a user_objects view have an entry for a trigger?

969

---

How many tables can a sql database have?

932

---

How much does sql certification cost?

1026

---

Do prepared statements prevent sql injection?

904

---

Explain the savepoint statement.

1050

---

how to use case expression? : Sql dba

967

---

How do you rank data in sql?

947

---

How do I clear the screen in sql plus?

990

---

What are the different types of dbmss?

973

---