t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.

2 Answers   MasterCard,

---

What is a data lock in oracle?

0 Answers  

---

A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?

2 Answers  

---

What is the difference between substr & instr functions?

0 Answers  

---

How to rename a tablespace in oracle?

0 Answers  

---

---

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

3 Answers  

---

What are the factors causing the reparsing of SQL statements in SGA?

1 Answers  

---

why can't we assign not null constraint as table level constraint

3 Answers   CTS, Wipro,

---

Can we insert data in view oracle?

0 Answers  

---

How to apply filtering criteria at group level in oracle?

0 Answers  

---

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?

5 Answers   Zensar,

---

What is a database schema in oracle?

0 Answers  

---