Can i use Commit inside the Trigger? Suppose i use commit
what will be happy (it's complied /executed/work)
Answer Posted / swapna
commit,rollback and savepoint cannot be used in a trigger
directly, but it can be called in a stored procedure
present in the trigger. however it is usually avoided as it
might have sideeffects in transactions.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Advantages and disadvantages of stored procedure?
What is #table in sql?
Can unique keys be null?
How to download oracle sql developer?
What is the use of <> sql?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
Does access use sql?
Why do we use triggers?
What are the features of pl sql?
What are the advantages of sql?
Why do you partition data?
explain the difference between bool, tinyint and bit. : Sql dba
What are the sql versions?
What does partition by mean in sql?
What does varchar include?