Jenkins Pipeline: Loop Multiple Databases
Here is an example for using Jenkins to loop through multiple Oracle databases (pluggable databases in this case), and execute
Read more
PL/SQL
APEX: Fetch CLOB data via AJAX callback.
In my use case, I needed to fetch data (JSON) larger than 32k into a JavaScript variable. In APEX versions
Read moreColor Spectrum in APEX report
I recently had the need to display a color spectrum, depending on a column value, in a report. The colors
Read moreSQL Developer SSH connection
If you have to access databases that can only be reached through SSH connections, you can configure SQL Developer (4.1)
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 moreSQLd360 v3 now available, new features and (hopefully) less bugs!
SQLd360 v3 now available, new features and (hopefully) less bugs!.
Read moreMeet “edb360”: a free tool that provides a 360-degree view of an Oracle database
Meet "edb360": a free tool that provides a 360-degree view of an Oracle database.
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 moreApex 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 moreUsing Notepad++ with PL/SQL
http://sourceforge.net/apps/mediawiki/notepad-plus/index.php?title=User_Defined_Language_Files
Read more