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
What are the execution control statements in oracle?
What is a proxy class?
How do I reset a sequence in oracle?
How will you write a query to get a 5th rank student from a table student_report?
What happens if you use a wrong connect identifier?
Where do you use decode and case statements?
What is a sub query and what are the different types of subqueries?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What are operators in oracle?
What is a database table in oracle?
How do I uninstall oracle client from windows?
What is meant by an index?
When system tablespace is created?
How to define an external table with a text file?
What is an Oracle index?