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 is partitioned table in Oracle?
How to assign values to data fields in record variables?
How translate command is different from replace?
Explain the types of exception?
How to use "startup" command to start default instance?
How to save query output to a local file?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
Why is oracle so popular?
What is an oracle user account?
State the various uses of dbcc command?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
How to load a large xml file?
How to drop a stored function?
Can a formula column be obtained through a select statement ?
How will you write a query to get a 5th rank student from a table student_report?