pl/sql – Page 2 – Christoph's 2 Cents

Using Notepad++ with PL/SQL

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

I often have some test code that spans multiple lines in my PL/SQL programs that I need to comment/un-comment frequently.

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.

Here is a quick example of how to loop through an associative array (index-by table) indexed by varchar2: [sourcecode language=”sql”]

This regular expression will parse out numbers with or without decimals. In this case, the number has to be surrounded

Quick Datapump Trick Using the expdp/impdp datapump utilities on Unix/Linux can be a bit tricky when it comes to formulating