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

How to use subqueries with the exists operator in oracle?

1070

---

How do you bind variables in oracle?

1022

---

What happens if the imported table already exists?

1077

---

What are the different types of partitions in oracle?

1032

---

What is oracle analytical function?

1229

---

Explain what are clusters?

1156

---

what is the difference between data migration and production migration.

2398

---

Where is the export dump file located?

1224

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2180

---

Explain what are the type of synonyms?

1185

---

What are the attributes of cursor?

1104

---

How to get a create statement for an existing table?

1014

---

State and explain about oracle instance?

1052

---

What happens if you use a wrong connect identifier?

1140

---

how the indexes are stored in the Oracle Database?

2334

---