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 importance of partitioning in dbms?

970

---

how Data is stored in a file so that Direct Searching can be performed

1015

---

What is the advantage of database management system?

915

---

What are the various kinds of interactions catered by dbms?

2133

---

What are the different types of database keys?

1029

---

What is tuple in dbms?

878

---

What is the purpose of sql?

947

---

Single File Database: Develop a student record management program, which uses single file as its database. It is not supposed to create additional files at any part of the project and should never rewrite total content. It must be capable of storing 100000's of records. It should support variable length records to be added, deleted, modified, listed.

2218

---

What are the applications of database?

886

---

What is trigger in dbms?

922

---

What do you understand by e-r model?

1023

---

Is filemaker pro a relational database?

1061

---

Can you explain the 'between' clause?

1127

---

What are its two major subsystems of r?

1151

---

What is the easiest database to learn?

893

---