SQLcl Aliases With Variables
Some example for adding parameters and variables to SQLcl aliases.
Read more
PL/SQL
Three Ways To Pass Environment Variables into SQLcl
Trying to reference an environment variable in SQLcl can be a bit tricky. Here are three ways you can do
Read more
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
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 more