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
Oracle Developement
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
Taming the Terraform Module Madness
I have to admit, Terraform module syntax has driven me mad. Especially since I’ve been away from Terraform since before
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
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 moreConnect Liquibase to Oracle Autonomous Database Using a Wallet
You can use a wallet to connect to an OCI Autonomous Database with Liquibase. To do this you need to
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
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