Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to use Transactional control statements in
Database ?
- 2 Answers
- 5211 Views
- I also Faced
- E-Mail Answers
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 |
What is data model example?
difference between generalisation,specialisation and aggregation? with examples.
What do you understand by data redundancy?
What is tuple and attribute?
What is normalisation and its type?
What are the Common SQL Functions Used for Data Aggregation?
What are the features of a database management system?
Which is the most used database?
How to unzip a file in ssis?
What is database or database management systems (dbms)? And what's the difference between file and database? Can files qualify as a database?
What do you understand by clause in sql?
What are the types of rdbms?
-
Oracle (3253) - 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)
