Answer / ddrema

It's posible and mandatory if you use AUTONOMOUS
TRANSACTION in the TRIGGER.
like this:
CREATE OR REPLACE TRIGGER audit_sal
BEFORE UPDATE OF salary ON employees FOR EACH ROW
DECLARE
PRAGMA AUTONOMOUS_TRANSACTION;
BEGIN
INSERT INTO emp_audit VALUES( :old.employee_id, SYSDATE,
:new.salary, :old.salary );
COMMIT;
END;
/

Answer / guest

no, it is not possible to use Transactional control
statements in Database Triggers

Write a note on File based system/ Data base system

2 Answers  

---

IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?

0 Answers  

---

In which format image is stored in database?

0 Answers  

---

Differentiate nested loop, hash join and merge join.

0 Answers  

---

Explain the Difference Between a Primary Key and a Foreign Key.

1 Answers  

---

What is advantage of dbms?

0 Answers  

---

What is a data type in a database?

0 Answers  

---

What is Archived Redo Log ?

3 Answers  

---

What is a database report?

0 Answers  

---

How to export data from database and import into another?

0 Answers  

---

Are databases stored on servers?

0 Answers  

---

What is openedge abl in terms of taking the perspective of the developer?

0 Answers  

---