Using Notepad++ with PL/SQL
http://sourceforge.net/apps/mediawiki/notepad-plus/index.php?title=User_Defined_Language_Files
Read morehttp://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: [sourcecode language=”sql”]
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