Neat little comment trick.
I often have some test code that spans multiple lines in my PL/SQL programs that I need to comment/un-comment frequently.
Read morepl/sql
Controlling 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
Quick Look: How to loop through an associative array indexed by varchar2.
Here is a quick example of how to loop through an associative array (index-by table) indexed by varchar2: [sourcecode language=”sql”]
Read moreRegular expression to parse out numbers with optional precision.
This regular expression will parse out numbers with or without decimals. In this case, the number has to be surrounded
Read moreQDT: Escape from Alcatraz
Quick Datapump Trick Using the expdp/impdp datapump utilities on Unix/Linux can be a bit tricky when it comes to formulating
Read more