Can you use a commit statement within a database trigger?
Answer Posted / charan
Hi this is charan...
Actually Not allowed TCL commands in trigger...but it is possible we are not use directly these commands...to over come this problem oracle introduced one concept is called "Autonomous Transactions" .through autonomous transaction we are using tcl commands in Trigger concept....This is according to my knowledge
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How can I combine multiple rows into a comma-delimited list in oracle?
How many types of segments in Oracle?
Which is better Oracle or MS SQL? Why?
What privilege is needed for a user to insert rows to tables in another schema?
Explain table?
What is ADDM Advisor in Oracle?
How do I escape a reserved word in oracle?
What is varray?
what are the advantages of running a database in archive log mode?
How to create a new table by selecting rows from another table?
What is a select query statement in oracle?
Please explain joins in oracle?
What are the advantages of oracle 12c?
What is the string concatenation operator in oracle?
Explain the use of analyse option in exp command.