What is an autonomous transaction and which databases natively support it?

Advanced SQL Developer Hard

Advanced SQL Developer — Hard

What is an autonomous transaction and which databases natively support it?

Key points

  • Autonomous transactions run separately from the main transaction
  • They can commit or rollback without impacting the parent transaction
  • Oracle supports autonomous transactions with PRAGMA AUTONOMOUS_TRANSACTION
  • PostgreSQL offers partial support through dblink

Ready to go further?

Start full exam Practice more questions

Related questions