Is it possible to use Transactional control statements in Database ?

Is it possible to use Transactional control statements in
Database ?

Question Posted / guest

2 Answers
5018 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Is it possible to use Transactional control statements in Database ?..

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

Is This Answer Correct ?

2 Yes

0 No

Is it possible to use Transactional control statements in Database ?..

Answer / guest

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

Is This Answer Correct ?

0 Yes

1 No

Post New Answer

More Database Management Interview Questions

How to create student table through query with a numeric column of ID and Name of Chaeacter and D-O-B with date type in database What will be the query for this purpose?

0 Answers PUCIT,

I want to export the data date to date from oracle database then what can i do?

0 Answers

Explain the syntax of named procedure?

0 Answers

What is a database management system and give examples?

0 Answers

Are Constraints exported through Export command?

1 Answers

Which dbms is best?

0 Answers

What are the ACID Properties in a Database and Why are They Important?