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....

how can we submit a form without a submit button? : Sql dba

983

---

how many sql dml commands are supported by 'mysql'? : Sql dba

1113

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

979

---

Where not exists in sql?

974

---

Explain autonomous transaction.

1152

---

Why schema is used in sql?

1045

---

Which join is default?

948

---

how to check myisam tables for errors? : Sql dba

1319

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

1024

---

how to create a new table in mysql? : Sql dba

983

---

What is the difference between unique and primary key constraints?

1065

---

What is the best partition size for windows 10?

996

---

What are different sql data types?

1037

---

What is pl sql script?

1026

---

How can you load microsoft excel data into oracle? : aql loader

1171

---