Answer Posted / saraswathi muthuraman

Trigger will be compiled. while execution r error will occur.
To avoid this you can use PRAGMA autonomus_transaction

example :

create or replace trigger emp_test_trig
after update on emp_test
for each row
declare
PRAGMA autonomus_transaction;
begin

insert into dep_test values(100,:new.emp_id);
commit;
end;
/

What are the advantages of sql? Explain

1147

---

Does sqlite need a server?

1094

---

Why do we create stored procedures & functions in pl/sql and how are they different?

990

---

How long will it take to learn pl sql?

976

---

What is the difference between alter trigger and drop trigger statements?

1156

---

What is blind sql injection?

1162

---

Is microsoft sql free?

1136

---

What is sql trigger example?

1108

---

What is the need of a partition key?

1025

---

what is the bond code in materialized view?

3051

---

Does truncate free space?

1062

---

What is the difference between row level and statement level trigger?

1068

---

Can a primary key be a foreign key?

1075

---

Does group by remove duplicates?

1090

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1267

---