Skip to content

Christoph's 2 Cents

A Backup for My Brain!

  • About
  • Fun Stuff
  • OCI Newsletter

Oracle Developement

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

Read more
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

Read more
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.

Read more
selective focus photography of woman holding yellow petaled flowers
DevOps JavaScript Liquibase Oracle Developement Oracle Tools PL/SQL 

Three Ways To Pass Environment Variables into SQLcl

October 3, 2022September 30, 2022 cruepprich

Trying to reference an environment variable in SQLcl can be a bit tricky. Here are three ways you can do

Read more
Cloud DevOps Liquibase Oracle Cloud Infrastructrure Oracle Developement 

Connect Liquibase to Oracle Autonomous Database Using a Wallet

June 28, 2022June 28, 2022 cruepprich

You can use a wallet to connect to an OCI Autonomous Database with Liquibase. To do this you need to

Read more
green plant covered with snow
APEX Cloud DevOps Linux Oracle Application Express (Apex) Oracle Cloud Infrastructrure Oracle Developement Oracle Linux 

Run ORDS as a systemd Service

February 22, 2021February 22, 2021 cruepprich

In this example, I configure ORDS to run as a systemd service. This way ORDS runs in the background and

Read more
Cloud DevOps Groovy Jenkins Oracle Cloud Infrastructrure Oracle Developement Oracle Tools PL/SQL 

Jenkins Pipeline: Loop Multiple Databases

June 30, 2020June 30, 2020 cruepprich devops, groovy, jenkins, oracle, pipeline, plssql, sql

Here is an example for using Jenkins to loop through multiple Oracle databases (pluggable databases in this case), and execute

Read more
Ajax APEX Cloud JavaScript Oracle Application Express (Apex) Oracle Developement PL/SQL 

APEX: Fetch CLOB data via AJAX callback.

April 6, 2020April 9, 2020 cruepprich ajax, apex, apex.ajax.clob, application express, callback, dynamic action, javascript, oracle, pl/sql

In my use case, I needed to fetch data (JSON) larger than 32k into a JavaScript variable. In APEX versions

Read more
Cloud DevOps Oracle Cloud Infrastructrure Oracle Developement Oracle Tools Terraform 

Terraforming Power with CSV Files

February 24, 2020May 18, 2021 cruepprich cloud, infrastructure as code, oci, oracle, terraform

It is often easier to collect resource information for Terraform through spreadsheets. In this example, I’ll build a number of

Read more
Cloud Oracle Developement Terraform 

Terraform Import OCI Resources

June 12, 2019 cruepprich cloud, oci, terraform

Terraform allows you to re-create a state file (terraform.tfstate) with the import command. For the import, you need to specify

Read more
  • ← Previous
Oracle ACE
Copyright © 2023 Christoph's 2 Cents. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.