PL/SQL – Page 3 – Christoph's 2 Cents

A Backup for My Brain!

Logarithmic Apex Charts

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:

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