Exporting APEX with Original IDs
APEX has the option to export applications with original IDs. What does that mean and why should it be used?
Read More
Christoph's 2 Cents
A Backup for My Brain!
PL/SQL
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
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 More