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 the max number of columns in an oracle table?
How to execute the package in oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How to drop an existing view in oracle?
Give the various rollback segment states.
What is the difference between "as" and "is" in an oracle stored procedure?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
How to create a new table in oracle?
How do I escape a reserved word in oracle?
How do I find the database name in oracle?
How many types of database triggers exist?
Is oracle a relational database?
What is raw datatype in oracle?
What is oracle database 10g express edition?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?