Interested to Buy Any Domain ? << Click Here >> for more details...
Can i use Commit inside the Trigger? Suppose i use commit
what will be happy (it's complied /executed/work)
- 6 Answers
- 14991 Views
- I also Faced
- E-Mail Answers
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
how many ways we can we find the current date using mysql? : Sql dba
What program will open a mdb file?
What are sql procedures?
what is acid property in database? : Sql dba
What is the difference between sql and mysql?
What is the difference between clustered and non-clustered indexes?
Can we have two clustered index on a table?
How to write html code in pl sql?
how to convert character strings to numeric values? : Sql dba
Is sql difficult?
What is the difference between partitioning and sharding?
Which command is used to call a stored procedure?
what is a table in a database ? : Sql dba
Which join condition can be specified using on clause?
List and explain the different types of join clauses supported in ansi-standard sql?
