Is it possible to use Transactional control statements in
Database ?
Answers were Sorted based on User's Feedback
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 |
Answer / guest
no, it is not possible to use Transactional control
statements in Database Triggers
| Is This Answer Correct ? | 0 Yes | 1 No |
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?
I want to export the data date to date from oracle database then what can i do?
Explain the syntax of named procedure?
What is a database management system and give examples?
Are Constraints exported through Export command?
Which dbms is best?
What are the ACID Properties in a Database and Why are They Important?
What is a table called in database?
What is the difference between a catalog and a database?
How do I check my drivers?
How can you get data from a database in an Excel sheet?
write a query to Find the Maximun second value in table?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)