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 make an oracle object
What is translate in oracle?
How many types of synonyms in Oracle?
How to load data through external tables?
What is a system tablespace and when it is created?
How to export data with a field delimiter?
What is the Tune Query
What is Java Pool in Oracle?
How to count groups returned with the group by clause in oracle?
What is backup in Oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How to define an external table with a text file?
How to connect to a remote server?
What are the execution control statements in oracle?