Christoph's 2 Cents – A Backup for My Brain!

APEX DevOps Oracle Application Express (Apex) Oracle Developement Oracle Tools PL/SQL

Exporting APEX with Original IDs

October 6, 2023October 31, 2023 cruepprich

APEX has the option to export applications with original IDs. What does that mean and why should it be used?

closeup photo of eyeglasses

Cloud DevOps JavaScript Oracle Developement OS X (Mac) shell scripting

Configure GraalVM on Mac OS for running JavaScript in SQLcl

September 7, 2023September 7, 2023 cruepprich

You may have already come across Jeff Smith’s post How to run JavaScript in Oracle SQLcl with Java 17. To

a group of palm trees in front of a purple sky

JavaScript Oracle Developement Oracle Tools PL/SQL

SQLcl JavaScript: Using Bind Variable in Queries

August 29, 2023August 28, 2023 cruepprich

Here are some quick examples of using bind variables in SQL queries in JavaScript inside SQLcl. Usage: Copy the examples

DevOps JavaScript Oracle Application Express (Apex) Oracle Developement Oracle Tools PL/SQL

Saving Private BLOB: Extracting a BLOB to the Local Filesystem With SQLcl.

July 11, 2023August 28, 2023 cruepprich blob, export, files

Using a hybrid SQLcl script to fetch a BLOB from a procedure and writing it to the local (client) filesystem.

Lioness Roaring

bash DevOps Oracle Cloud Infrastructrure Oracle Developement shell scripting Terraform

Taming the Terraform Module Madness

March 6, 2023March 9, 2023 cruepprich apply, best practices, blocks, child, configuration, definitions, encapsulate, files, management, module, modules, resource, simplify, stack, syntax, terraform, vs.

I have to admit, Terraform module syntax has driven me mad. Especially since I’ve been away from Terraform since before

three clear drinking glasses on brown wooden table

bash DevOps jq Linux Oracle Linux shell scripting

“Beer, Bash, and jq: Parsing JSON Like a Pro!”

March 2, 2023March 2, 2023 cruepprich Bash programming, Command-line interfaces, CSV output, Data analysis, Data extraction, Data manipulation, jq command, JSON configuration files, JSON data formatting, JSON files, JSON parsing, Linux commands, Programming tools, Tech tutorials

Let me explain: Beer: You should already know what this is 🍺. Bash: You should probably know what this is,

Ansible Cloud DevOps Oracle Cloud Infrastructrure Terraform

Ansible vs. remote-exec: Choosing the Best Approach for Oracle Cloud Infrastructure Configuration

February 24, 2023February 24, 2023 cruepprich

When using Terraform to provision infrastructure on Oracle Cloud, you have several options for configuring your instances. Two of the

MPC One/Live/X – Multiple Templates

February 14, 2023February 14, 2023 cruepprich

As of MPC version 2.11.6, a user can only select from one of two templates: The default empty template, and

red and black plastic crates

APEX DevOps JavaScript Liquibase Oracle Cloud Infrastructrure Oracle Tools

Bulk Install APEX Applications with SQLcl Liquibase

December 15, 2022December 15, 2022 cruepprich

The following code uses a JavaScript that can install multiple exported APEX applications, by looping over the export directories and

DevOps Oracle Developement Oracle Linux Oracle Tools PL/SQL

SQLcl Aliases With Variables

October 7, 2022 cruepprich

Some example for adding parameters and variables to SQLcl aliases.

← Previous