Answer Posted / 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;

What is pragma autonomous transaction in oracle?

1070

---

What is the difference between 10g OEM and 11g OEM?

965

---

how to clone 9i Database on to 10g Database.

2339

---

Why is oracle so popular?

997

---

What is the difference between sharding and replication?

1048

---

What is oracle analytical function?

1143

---

What is an oracle database table?

1015

---

Describe varray?

1058

---

How to update values in a table in oracle?

1026

---

What privilege is needed for a user to create tables in oracle?

953

---

How to convert dates to characters in oracle?

1041

---

Why use resource manager in Oracle?

1105

---

How to create an oracle database?

1041

---

6. Display the client name and order date for all orders using the traditional method.

2306

---

What is connection pooling in oracle?

973

---