How do I find out if an oracle database is set to autocommit?

Viewed 48181

And while we're at it, how do I switch between autocommit and non-autocommit?

3 Answers

Try command show autocommit from command prompt. Steps:

  • Open SQL*PLUS from command prompt in admin mode
  • Type command show autocommit
Related