Answer Posted / sohini
Autonomous transactions let you suspend the main
transaction, do SQL operations in the procedure or function
in which it has been declared, commit or roll back those
operations, then resume the main transaction.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use existing values in update statements using oracle?
How remove data files before opening a database?
What is a table in oracle?
What are group functions in oracle?
How to delete an existing row from a table in oracle?
Why cursor variables are easier to use than cursors?
How to view the data files in the current database?
How to use fetch statement in a loop?
How to create lov dynamically at runtime & attach to text field?
How to join two tables in a single query using oracle?
Why packages are used in oracle?
What is the disadvantage of User defind function?
What is the difference between PFILE and SPFILE in Oracle?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What is the difference between a hot backup and a cold backup in oracle?