SQLcl Aliases With Variables
Some example for adding parameters and variables to SQLcl aliases.
Read more
Oracle Developement
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
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 moreTerraforming Power with CSV Files
It is often easier to collect resource information for Terraform through spreadsheets. In this example, I’ll build a number of
Read moreTerraform Import OCI Resources
Terraform allows you to re-create a state file (terraform.tfstate) with the import command. For the import, you need to specify
Read more
Oracle Magazine: Voice Assistants
Here is a reblog of an Oracle Magazine article for which I was interviewed:https://blogs.oracle.com/oraclemagazine/hey%2c-data-experts%3a-voice-assistants-are-calling-your-name
Read more
OCI Command Line Interface (CLI) Basics
The OCI Command Line Interface (CLI), is a Python-based command line interpreter, that lets you interact with the Oracle Cloud
Read more