Meet “edb360”: a free tool that provides a 360-degree view of an Oracle database
Meet "edb360": a free tool that provides a 360-degree view of an Oracle database.
Read moreplsql
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.
Read moreSpeaking at RMOUG Training Days 2014
I’m honored to be allowed to present at this year’s RMOUG Training Days. My presentation Making Sense of Application Express Security,
Read moreFind ancestor from hierarchy
I needed to find a quick way to select a particular ancestor for a child in a hierarchical table. For
Read moreUsing Notepad++ with PL/SQL
http://sourceforge.net/apps/mediawiki/notepad-plus/index.php?title=User_Defined_Language_Files
Read moreControlling SYSDATE
For certain testing scenarios, I need to have SYSDATE return a certain date. This can be done with Oracle’s FIXED_DATE
Read moreLogarithmic Apex Charts
If you have a chart with a large difference between the highest and lowest values, you may find that the
Read moreCopying one associative array to another.
If you have two associative arrays (PL/SQL tables), and want to copy the contents of one to another, rather than
Read moreSend email through Gmail
Here is an excellent article on how to send email through PL/SQL, using Gmail as the smtp server.
Read moreDBMS_RESOURCE_MANAGER and Apex
DBMS_RESOURCE_MANAGER and Apex
Here is an excellent post by Joel Kallman on how to use DBMS_RESOURCE_MANAGER to control the impact Apex has on the database.
Read more