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
Oracle Application Express (Apex)
ORDS Standalone: Configure SSL Certificate Chain
This post describes the process for installing an SSL certificate chain in ORDS running in Standalone mode. Prerequisites: One instance
Read more
Run ORDS as a systemd Service
In this example, I configure ORDS to run as a systemd service. This way ORDS runs in the background and
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 moreAPEX 5 Theme/Static files issue (503 error)
I’ve recently come across the issue of static images not working and my custom theme roller theme not being applied
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 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 more