RIP
Tutorial
Tags
Topics
Examples
eBooks
Download Oracle Database (PDF)
Oracle Database
Getting started with Oracle Database
Awesome Book
Awesome Community
Awesome Course
Awesome Tutorial
Awesome YouTube
Anonymous PL/SQL Block
Autonomous Transactions
Using autonomous transaction for logging errors
constraints
Creating a Context
Data Dictionary
Data Pump
Database Links
Dates
Delimiting keywords or special characters
Different ways to update records
DUAL table
Dynamic SQL
Error logging
Handling NULL values
Hierarchical Retrieval With Oracle Database 12C
Hints
Indexes
JOINS
level query
Limiting the rows returned by a query (Pagination)
Oracle Advanced Queuing (AQ)
Oracle MAF
Real Application Security
Recursive Sub-Query Factoring using the WITH Clause (A.K.A. Common Table Expressions)
Sequences
Splitting Delimited Strings
Statistical functions
String Manipulation
Table partitioning
Update with Joins
Window Functions
Working with Dates
Oracle Database
Getting started with Oracle Database
Awesome Book
Awesome Community
Awesome Course
Awesome Tutorial
Awesome YouTube
Anonymous PL/SQL Block
Autonomous Transactions
Using autonomous transaction for logging errors
constraints
Creating a Context
Data Dictionary
Data Pump
Database Links
Dates
Delimiting keywords or special characters
Different ways to update records
DUAL table
Dynamic SQL
Error logging
Handling NULL values
Hierarchical Retrieval With Oracle Database 12C
Hints
Indexes
JOINS
level query
Limiting the rows returned by a query (Pagination)
Oracle Advanced Queuing (AQ)
Oracle MAF
Real Application Security
Recursive Sub-Query Factoring using the WITH Clause (A.K.A. Common Table Expressions)
Sequences
Splitting Delimited Strings
Statistical functions
String Manipulation
Table partitioning
Update with Joins
Window Functions
Working with Dates
Oracle Database
Autonomous Transactions
Help us
to keep this website almost Ad Free! It takes only
10 seconds
of your time:
> Step 1
: Go view our video on YouTube:
EF Core Bulk Insert
> Step 2
: And Like the video. BONUS: You can also share it!
Remarks
Typical use cases for autonomous transaction are.
For building any kind of logging framework like the error logging framework explained in the above example.
For auditing DML operations in triggers on tables irrespective of the final status of the transaction (COMMIT or ROLLBACK).
Autonomous Transactions Related Examples
Using autonomous transaction for logging errors
Got any Oracle Database Question?
Ask any Oracle Database Questions and Get Instant Answers from ChatGPT AI:
ChatGPT answer me!
PDF
- Download
Oracle Database
for free
Previous
Next
Cookie
This website stores cookies on your computer.
We use cookies to enhance your experience on our website and deliver personalized content.
For more details on our cookie usage, please review our
Cookie Policy
and
Privacy Policy
Accept all Cookies
Leave this website