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
Why use resource manager in Oracle?
What is bulk copy or bcp in oracle?
How to manage transaction isolation level?
how to join query for one source type is oracle another source type is sql server ?
How many types of cluster table in Oracle?
How to handle a single quote in oracle sql?
Explain compound trigger in oracle?
What are the differences between blob and clob in oracle?
What is a nested table?
Explain cascading triggers.
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
When do I need to use a semicolon vs a slash in oracle sql?
How many types of tables supported by oracle?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
IS it possible to built the oracle database without setting the kernal parameters?