Configure GraalVM on Mac OS for running JavaScript in SQLcl
You may have already come across Jeff Smith’s post How to run JavaScript in Oracle SQLcl with Java 17. To
Read more
JavaScript
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
Bulk Install APEX Applications with SQLcl Liquibase
The following code uses a JavaScript that can install multiple exported APEX applications, by looping over the export directories and
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
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 more