Autonomous Transaction in Oracle PL/SQL - Shikshaglobe

An autonomous transaction is a PL/SQL block that contains one or more SQL statements and operates independently of the calling program. Once an autonomous transaction starts, it can do anything that any other transaction can do. This includes issuing commits and rollbacks. Because an autonomous transaction is independent, it has no effect on the calling program's work. For example, if the calling program issues a rollback, any changes made by the autonomous transaction are not undone.An autonomous transaction is a self-contained subprogram that executes independently of the program that calls it. An autonomous transaction can have its own COMMIT and ROLLBACK statements, which enables it to commit or rollback its changes, even if the caller's transaction is rolled back. Autonomous transactions are useful for ensuring data integrity, even if the containing transaction fails.An autonomous transaction is an independent transaction that can be committed or rolled back without affecting the main transaction. Autonomous transactions are useful for tasks that cannot be included in the main transaction, such as auditing or logging.Autonomous transactions are created using the AUTONOMOUS_TRANSACTION pragma. This pragma tells the PL/SQL compiler to treat a subprogram as an autonomous transaction. The subprogram can then have its own COMMIT and ROLLBACK statements, which do not affect the enclosing program.

Tags:

autonomous transaction in oracle pl/sqlpragma autonomous_transaction in oracle pl sql examplepragma autonomous_transaction in oracle pl sql functionwhat is an autonomous transaction in oracleuse of autonomous transaction in oracleautonomous transaction in oracle trigger exampleautonomous transaction in oracle pl/sql apexautonomous transaction in oracle pl/sql andautonomous transaction in oracle pl/sql applicationautonomous transaction in oracle pl/sql alter tableautonomous transaction in oracle pl/sql and statementautonomous transaction in oracle pl/sql add columnautonomous transaction in oracle pl/sql bigintautonomous transaction in oracle pl/sql betweenautonomous transaction in oracle pl/sql blockautonomous transaction in oracle pl/sql bookautonomous transaction in oracle pl/sql bigqueryautonomous transaction in oracle pl/sql between datesautonomous transaction in oracle pl/sql cursorautonomous transaction in oracle pl/sql cursor exampleautonomous transaction in oracle pl/sql codeautonomous transaction in oracle pl/sql connectionautonomous transaction in oracle pl/sql case statementautonomous transaction in oracle pl/sql certificationautonomous transaction in oracle pl/sql caseautonomous transaction in oracle pl/sql create tableautonomous transaction in oracle pl sql createautonomous transaction in oracle pl/sql developerautonomous transaction in oracle pl/sql differenceautonomous transaction in oracle pl/sql decimalhow to use autonomous transaction in oracleautonomous transaction in oracle pl/sql grantautonomous transaction in oracle pl/sql goautonomous transaction in oracle pl/sql group byautonomous transaction in oracle pl/sql howautonomous transaction in oracle pl/sql helpautonomous transaction in oracle pl/sql hanaautonomous transaction in oracle pl/sql havingautonomous transaction in oracle pl/sql having clauseautonomous transaction in oracle pl/sql interview questionsautonomous transaction in oracle pl/sql inautonomous transaction in oracle pl/sql in oracleautonomous transaction in oracle pl/sql in clauseautonomous transaction in oracle pl/sql injectionautonomous transaction in oracle pl/sql insertautonomous transaction in oracle pl sql is pragmaautonomous transaction in oracle pl/sql jobautonomous transaction in oracle pl/sql javaautonomous transaction in oracle pl/sql joinautonomous transaction in oracle pl/sql keyautonomous transaction in oracle pl/sql killautonomous transaction in oracle pl/sql keywordautonomous transaction in oracle pl/sql loopautonomous transaction in oracle pl/sql likeautonomous transaction in oracle pl/sql leftautonomous transaction in oracle pl/sql languageautonomous transaction in oracle pl/sql left joinautonomous transaction in oracle pl/sql limitautonomous transaction in oracle pl/sql meaningautonomous transaction in oracle pl/sql methodautonomous transaction in oracle pl/sql mergeautonomous transaction in oracle pl/sql merge statementautonomous transaction in oracle pl/sql management studioautonomous transaction in oracle pl/sql maxautonomous transaction in oracle pl/sql not workingautonomous transaction in oracle pl/sql not nullautonomous transaction in oracle pl/sql numberautonomous transaction in oracle pl/sql not equalautonomous transaction in oracle pl/sql not inautonomous transaction in oracle pl/sql oracleautonomous transaction in oracle pl/sql oracle exampleautonomous transaction in oracle pl/sql order byautonomous transaction in oracle pl/sql outputautonomous transaction in oracle pl/sql onlineoracle pl sql transaction examplewhat is pl/sql in oracleautonomous transaction in oracle pl/sql queryautonomous transaction in oracle pl/sql query exampleautonomous transaction in oracle pl/sql questionsautonomous transaction in oracle pl/sql quizletautonomous transaction in oracle pl/sql resultsautonomous transaction in oracle pl/sql row_numberautonomous transaction in oracle pl/sql rightautonomous transaction in oracle pl/sql rowautonomous transaction in oracle pl/sql replaceautonomous transaction in oracle pl/sql roundautonomous transaction in oracle pl/sql scriptautonomous transaction in oracle pl/sql sqlautonomous transaction in oracle pl/sql script exampleautonomous transaction in oracle pl/sql serverautonomous transaction in oracle pl sql sautonomous transaction in oracle pl sql s pragmaoracle autonomous transactionsautonomous transaction in oracle pl/sql tutorialautonomous transaction in oracle pl/sql tableautonomous transaction in oracle pl/sql table exampleautonomous transaction in oracle pl sql trigger pragmaautonomous transaction in oracle pl/sql usingautonomous transaction in oracle pl/sql updateautonomous transaction in oracle pl/sql unionautonomous transaction in oracle pl/sql update statementautonomous transaction in oracle pl/sql versionautonomous transaction in oracle pl/sql variableautonomous transaction in oracle pl/sql visual studioautonomous transaction in oracle pl/sql vs sqlautonomous transaction in oracle pl/sql vs nosqlautonomous transaction in oracle pl/sql vs mysqlautonomous transaction in oracle pl/sql w3schoolsautonomous transaction in oracle pl/sql where clauseautonomous transaction in oracle pl/sql withautonomous transaction in oracle pl/sql with exampleautonomous transaction in oracle pl/sql workbenchautonomous transaction in oracle pl sql what is pragmaautonomous transaction in oracle pl/sql xmlautonomous transaction in oracle pl/sql xpathautonomous transaction in oracle pl/sql xml exampleautonomous transaction in oracle pl/sql youtubeautonomous transaction in oracle pl/sql yearautonomous transaction in oracle pl/sql youtube videoautonomous transaction in oracle pl/sql year functionautonomous transaction in oracle pl/sql zeroautonomous transaction in oracle pl/sql z/osautonomous transaction plsqlautonomous transaction oracle exampleautonomous transaction oracle