SQLcl JavaScript: Using Bind Variable in Queries
Here are some quick examples of using bind variables in SQL queries in JavaScript inside SQLcl. Usage: Copy the examples
Read more
PL/SQL
Saving Private BLOB: Extracting a BLOB to the Local Filesystem With SQLcl.
Using a hybrid SQLcl script to fetch a BLOB from a procedure and writing it to the local (client) filesystem.
Read more
SQLcl Aliases With Variables
Some example for adding parameters and variables to SQLcl aliases.
Read more
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 more
Hierarchical Query: Roll-up leaf nodes to ancestors.
This query may be more applicable to a bill of materials type of query. I’ve added a new column to
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 more