Archive for the 'Tools' Category

OPP 2010

Wednesday, August 25th, 2010

On October 27th and 28th the combined OPP (Oracle PL/SQL Programming) and APEXposed conference is coming to Europe. To Brussels to be exact. I have had the privilege to attend these conferences since the first one in 2005. The nice thing about this conference is that it is the only conference (at least that I [...]

Semaphores (revisited)

Wednesday, May 6th, 2009

In a previous blog I talked about turning triggers on and off using semaphores. I created a semaphore for every table I needed along with its programs to set and unset the semaphore and to get its current state. This was a rather cumbersome process, because for every new trigger I needed to add these [...]

Display images with PL/SQL Developer

Wednesday, March 18th, 2009

Alex wrote an entry on displaying images stored as a BLOB in the database here. Since PL/SQL Developer is my (and his) favorite editor, I figured I would do the same he did, but this time using PL/SQL Developer.

Template plug-in…

Wednesday, March 4th, 2009

A while ago I created a plug-in for PL/SQL developer that allowed me to type in a short code, press a magic key and have the short code replaced by the contents of my template. For instance, I type put, press CTRL-J and the code I typed in gets replaced by dbms_output.put_line();. That’s a [...]

Code refactoring…

Friday, December 12th, 2008

Steven Feuerstein wrote an entry on his Toadworld blog where he checks the refactoring capabilities of SQL-Developer.
I am trying the same things in PL/SQL Developer to see if this does do the trick.