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
What is bind variable in pl sql?
What is example of database?
Can I create table without primary key?
What is join view in sql?
what is 'trigger' in sql? : Sql dba
How do you delete data from a table?
what is 'mysqladmin' in mysql? : Sql dba
Explain the select statement in sql?
How many sql core licenses do I need?
What is trigger and stored procedure in sql?
What are %type and %rowtype for?
What is the use of index in sql?
What are the types of index in sql?
What is multiple columns?
What are the disadvantages of not performing database normalization?