Using Notepad++ with PL/SQL
http://sourceforge.net/apps/mediawiki/notepad-plus/index.php?title=User_Defined_Language_Files
Read MoreA Backup for My Brain!
http://sourceforge.net/apps/mediawiki/notepad-plus/index.php?title=User_Defined_Language_Files
Read MoreI often have some test code that spans multiple lines in my PL/SQL programs that I need to comment/un-comment frequently.
Read MoreFor certain testing scenarios, I need to have SYSDATE return a certain date. This can be done with Oracle’s FIXED_DATE
Read MoreIf you have a chart with a large difference between the highest and lowest values, you may find that the
Read MoreIf you have two associative arrays (PL/SQL tables), and want to copy the contents of one to another, rather than
Read MoreHere is an excellent article on how to send email through PL/SQL, using Gmail as the smtp server.
Read MoreDBMS_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
Here is a quick example of how to loop through an associative array (index-by table) indexed by varchar2:
Read MoreThis regular expression will parse out numbers with or without decimals. In this case, the number has to be surrounded
Read MoreQuick Datapump Trick Using the expdp/impdp datapump utilities on Unix/Linux can be a bit tricky when it comes to formulating
Read More