Can you use a commit statement within a database trigger?
Answer Posted / usingh
Yes, using AUTONOMOUS_TRANSACTION Pragma you can COMMIT and ROLLBACK.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Is there a combination of "like" and "in" in sql?
What is max rowid in oracle?
What are the logical operations?
What is hot backup and logical backup?
What is a table index?
What is open database communication (odbc) in oracle?
What is ADDM Advisor in Oracle?
What is the difference between 10g OEM and 11g OEM?
does the query needs a hint to access a materialized view?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What to do if the binary spfile is wrong for the default instance?
How many types of table in Oracle?
What is oracle rowcount?
How to display employee records who gets more salary than the average salary in the department?