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
How to see free space of each tablespace?
Explain a synonym?
What is key preserved table?
What is the use of oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to delete all rows a table in oracle?
What is the dynamic sql in oracle?
Explain what are the advantages of views?
Explain rename?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
Explain constraining triggers.
How to return top 5 rows in oracle?
Does oracle database need java?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What are the arithmetic operations?