Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ?
Answer Posted / deva
yes we cannot make TCL commands with in triggers. If the
block is declared as a autonomous transaction, then commit
and rollback can be given in the end of the block
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What are the types of functions in sql?
What is union, minus and interact commands?
What is #table in sql?
what is the difference between nested subquery and correlated subquery?
How much does a sql dba make? : SQL DBA
Is progress software supports to ( pl/sql )?
how to present a past time in hours, minutes and seconds? : Sql dba
How do you optimize a query?
How can you tell the difference between an index and a view?
How do I make sql search faster?
Explain aggregate functions are available there in sql?
Enlist some predefined exceptions?
- 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?
How do I run a sql query in pgadmin 4?
what is sql? : Sql dba