Answer Posted / 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;
/

What are the different types of keys in database?

824

---

What is domain in dbms?

898

---

What is the purpose of database management system?

990

---

How to schedule ssas database backup

942

---

Define primary and unique key?

983

---

Explain what is a deadlock and mention how it can be resolved?

826

---

What is dbms function?

930

---

Is the server accepting tcp ip connections on port 5432?

843

---

What is service based database?

840

---

Who is end user in database?

808

---

Explain 2nf?

896

---

Can files be stored in a database?

865

---

What is 1nf 2nf 3nf in dbms?

850

---

How to detect the server version?

971

---

What are the importance of database in banking?

907

---