Multi-Colored SQL

My OCD was delighted this morning when I came across a new feature of SQL Developer: Connection Color.  Brace yourselves, as this feature ain't much, but could have a huge impact on reducing accidental commands in the wrong schema or server.

To use it, simply create or edit a database connection, and set the Connection Color to whichever color you choose:

Once set, any and all windows associated with that connection will be outlined in (more...)

New APEX 4.2.3 Packaged Applications: Sample Reporting & Data Reporter

APEX 4.2.3 seems to be largely a maintenance release, with few new features added.  (Full details of what is included can be read here:

Despite this fact, there are a couple of new "features" that were added by way of a new packaged (more...)

Working with the APEX Tree

I found a great blog post by Tom Petrus that summarizes the power of the APEX tree here:

The post details a number of different attributes of the tree and how to interact with it.  It starts simple and shows how to get a tree reference (more...)

Oracle APEX @ OOW

Looks like the Oracle APEX team's annual OOW site is live here:  This site provides a list of APEX-related sessions at OOW in both a calendar and list view. It is also mobile friendly, which will make it nice to have while at the (more...)

New Book: Expert Oracle Application Express Security

I remember vividly meeting with Jonathan Gennick at RMOUG 2012 at the Apress booth.  As always, he asked if I was up for writing something APEX-related.  And as always, I politely declined, as I just had too much going on at the time.  However, before he let me leave the (more...)