plsql – Christoph's 2 Cents

Meet "edb360": a free tool that provides a 360-degree view of an Oracle database.

Excel Style Row Numbering in SQL

Here is a trick to change your rownumbering (or any other sequential numbering) to the way Excel names their columns.

I’m honored to be allowed to present at this year’s RMOUG Training Days. My presentation Making Sense of Application Express Security,

I needed to find a quick way to select a particular ancestor for a child in a hierarchical table. For

http://sourceforge.net/apps/mediawiki/notepad-plus/index.php?title=User_Defined_Language_Files

For certain testing scenarios, I need to have SYSDATE return a certain date. This can be done with Oracle’s FIXED_DATE

If you have a chart with a large difference between the highest and lowest values, you may find that the

If you have two associative arrays (PL/SQL tables), and want to copy the contents of one to another, rather than

Here is an excellent article on how to send email through PL/SQL, using Gmail as the smtp server.

Here is an excellent post by Joel Kallman on how to use DBMS_RESOURCE_MANAGER to control the impact Apex has on the database.