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
4546 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

i have a web page and in this page i create 3 textbax and a "summit" button do you have any html code for add text velue in my web page like link summation(form) sites.

0 Answers

Which is the best database?

0 Answers

Define phantom deadlock.

0 Answers

Enlist various types of interactions created by dbms?

0 Answers

What is artificial key?

0 Answers

Should database table names be capitalized?

0 Answers

write a query to retrieve the last day of next month in oracle.