Answer Posted / guru

----------- without AUTONOMOUS_TRANSACTION

CREATE or REPLACE TRIGGER parts_trig
BEFORE INSERT ON parts
FOR EACH ROW
BEGIN
INSERT INTO parts_log VALUES(:new.pnum, :new.pname);
END;
/
INSERT INTO parts VALUES (1040, 'Head Gasket');
COMMIT;
INSERT INTO parts VALUES (2075, 'Oil Pan');
ROLLBACK;

SELECT * FROM parts ORDER BY pnum;
SELECT * FROM parts_log ORDER BY pnum;

----------- using AUTONOMOUS_TRANSACTION

CREATE or REPLACE TRIGGER parts_trig
BEFORE INSERT ON parts FOR EACH ROW
DECLARE
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
INSERT INTO parts_log VALUES(:new.pnum, :new.pname);
COMMIT; -- only for AUTONOMOUS_TRANSACTION
END;
/
INSERT INTO parts VALUES (1040, 'Head Gasket');
COMMIT;
INSERT INTO parts VALUES (2075, 'Oil Pan');
ROLLBACK;
/


Please Check This


Thanks

Explain an index?

1134

---

How to open a cursor variable?

1035

---

What is an oracle and why it is used?

1150

---

What is oracle used for?

1026

---

Explain oracle data types with examples?

1028

---

What are the common oracle dba tasks?

1147

---

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2368

---

Calculate difference between 2 date / times in oracle sql?

1040

---

What is program global area (pga) in oracle?

1030

---

What are the numeric comparison operations?

1111

---

How to select some columns from a table in oracle?

1093

---

How to update values on multiple rows in oracle?

1034

---

Can we insert data in view oracle?

1035

---

How many types of segments in Oracle?

1070

---

How to put more than 1000 values into an oracle in clause?

1029

---