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
LDAP Authentication with APEX
Here is a quick tutorial on how to set up LDAP authentication with Oracle Application Express 4.1.1. Let’s assume that
Read moreApex: Accessing Tabular Form Column Values
I created a tabular report on a table and needed to write some custom code that does some DML based
Read moreControlling 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 more