Can you use a commit statement within a database trigger?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / karthik
yes, by autonomous transaction we can use commit.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / usingh
Yes, using AUTONOMOUS_TRANSACTION Pragma you can COMMIT and ROLLBACK.
Is This Answer Correct ? | 1 Yes | 1 No |
What is analyze command used for?
What is the max number of columns in an oracle table?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What is a nvl function? How can it be used?
Who developed oracle & when?
Please explain the difference between outer join and inner join? With examples would be appreciable..!
How can we find out the current date and time in oracle?
Which Department has MOST NUMBER of employees?
8 Answers IBM, LeadSquared, Mastek,
how to find the second highest salary in a given table????
What does a Control file Contain ?
i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?
what's query optimization and without use of IN AND Exist can we get another way data from query