Setting And Retrieving CLOB values in APEX with JavaScript
Here is a very helpful blog post by Andy Tulley on how to set/get CLOB values from an APEX collection.
Read morepl/sql
Where is my schema?
I just came accross a little nuisance: During attempt to load some spreadsheet data into a new table using the
Read moreAPEX 5: Convert Skillbuilder’s Modal to Universal Theme
If you have implemented the Skillbuilder’s Modal Page Plugin in an application of a previous version of APEX, and want
Read moreSet Session State with JavaScript and dynamic action
I have two page items, P1_FIRST_NAME and P1_LAST_NAME whose values I wish to remain in session state. Here are two ways
Read moreRandom Data Generator
Today I came across this awesome website which will automatically generate data for you, and spit it out in different
Read moreExcel Style Row Numbering in SQL
Here is a trick to change your rownumbering (or any other sequential numbering) to the way Excel names their columns.
Read moreEnkitec APEX Resource Center
I’m proud to announce the launch of the Enkitec APEX Resource Center (aka ARC) this week. It consists of a
Read moreFind ancestor from hierarchy
I needed to find a quick way to select a particular ancestor for a child in a hierarchical table. For
Read moreGeocoding with PL/JSON
The Google Maps API geocoding web service makes it easy to geocode addresses. You can pass an address to the
Read moreUsing Notepad++ with PL/SQL
http://sourceforge.net/apps/mediawiki/notepad-plus/index.php?title=User_Defined_Language_Files
Read more