Answer Posted / bernard raj
It is independent transaction.It will executes with out
interfering the parent transaction.
An autonomous transaction is an independent transaction started by another transaction, the main transaction. Autonomous transactions let you suspend the main transaction, do SQL operations, 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
Can a formula column referred to columns in higher group ?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
What exactly do quotation marks around the table name do?
What is translate in oracle?
How to put more than 1000 values into an oracle in clause?
What is the quickest way to fetch the data from a table?
What are the restrictions in a oracle read only transaction?
Is oracle a language?
How to run the anonymous block again?
Explain oracle’s system global area (sga).
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What are oracle functions?
what are the advantages of running a database in archive log mode?
What is using clause and give example?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
