Apex JSTree Nodes Remain Expanded After Page Refresh
To prevent a navigation JSTree to collapse after the page has been submitted, you need to have a page or
Read morePL/SQL
Using Notepad++ with PL/SQL
http://sourceforge.net/apps/mediawiki/notepad-plus/index.php?title=User_Defined_Language_Files
Read moreNeat 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 moreLDAP 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