Answer / uday

The best thing would be to create a trigger which checks and not allows duplicate data .

Create or replace trigger trig1
before insert or update on t1
for each row
declare
a number (10);
begin
select count(*) into a from t1 where col2 = :new.col2;
if a >= 1 then
raise_application_error(-20123,'data already present and data will not insert');
elsif a = 0 then
dbms_output.put_line('inserted');
end if;
end;

Answer / ravi gali

hi u can use DUP_VAL_ON_INDEX exception


SQL> create table test(id number primary key);



Table created.

SQL> set serverout on

SQL>

begin

insert into test values(1);

exception

when DUP_VAL_ON_INDEX then

raise_application_error('duplicate value entered on the row ');

when others then

dbms_output.put_line('if u entered wrong data');

end;

What is a Redo Log ?

3 Answers  

---

What are internal user account in oracle?

0 Answers  

---

what is insert all statement in sql

2 Answers   CGI, TCS,

---

What is the difference between a primary key & a unique key?

0 Answers  

---

How to load excel data sheet to oracle database

0 Answers  

---

How many types of database triggers exist?

0 Answers  

---

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

3 Answers   HCL,

---

What suggestions do you have to reduce the network traffic?

0 Answers  

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

0 Answers  

---

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 exactly do quotation marks around the table name do?

0 Answers  

---

Please explain oracle data types with examples?

0 Answers  

---