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
Oracle Tools
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
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
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
OCI Vault: Manage a Secret via CLI
The OCI Vault can help you store secrets such as encryption keys, passwords , and more. I won’t go into
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
OCI CLI: Query By Tags
Tagging your resources is a must. Not only for billing purposes, but also for staying organized and knowing who to
Read more