Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ?
Answer Posted / chintu
It is not possible. but if we want to put we use autonomous
transaction.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What is sqlerrd?
How do you break a loop in pl sql?
What do we need to check in database testing?
What do you understand by pl/sql cursors?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is cursor status?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
What is db journal file?
What are the operators used in select statements?
Does pl sql work in mysql?
What are instead of triggers?
What is basic structure of pl sql?
What is difference between primary and secondary key?
What is not null in sql?
How do I count records in sql?