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

Can we write insert statement in function in oracle?

1076

---

What do you understand by a database object?

1051

---

how the indexes are stored in the Oracle Database?

2267

---

Explain overloading. Can functions be overloaded?

974

---

How to start your 10g xe server?

1030

---

What is private procedure oracle?

1006

---

What are operators in oracle?

1050

---

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2253

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1061

---

How to change user password in oracle?

1019

---

Explain implicit cursor.

1012

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1014

---

How to delete an existing row from a table in oracle?

1064

---

Explain the difference between replace() and translate() functions in oracle?

1026

---

what is the difference between substr and instr function in oracle?

1075

---