Tag: transactions

Transaction subtleties

This came in from an AskTom question recently, and I thought it worth a blog mention because it could easily catch people out. Lets set the scene with a simple procedure that commences a transaction, but then always fails SQL> drop table test$tab purge;…

Avoiding the COMMIT bomb!

I’m an Oracle dinosaur, so I like using SQL Plus.  Its simple, fast, comes with every version and installation and platform, and I’m very familiar with it.  (And who knows, it might still be at the forefront of the Oracle development teams!  http://www.slideshare.net/hillbillyToad/sqlcl-overview-a-new-command-line-interface-for-oracle-database )…