Skip to content

Christoph's 2 Cents

A Backup for My Brain!

  • About
  • Fun Stuff
  • OCI Newsletter

Oracle Tools

shallow focus photography of computer codes
Oracle Application Express (Apex) Oracle Tools ORDS 

ORDS Standalone: Configure SSL Certificate Chain

August 30, 2021August 30, 2021 cruepprich

This post describes the process for installing an SSL certificate chain in ORDS running in Standalone mode. Prerequisites: One instance

Read more
grayscale photography of door lockers
Cloud DevOps Oracle Cloud Infrastructrure Oracle Tools 

OCI Vault: Manage a Secret via CLI

October 13, 2020March 31, 2022 cruepprich cli, oci, secrets, vault

The OCI Vault can help you store secrets such as encryption keys, passwords , and more. I won’t go into

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
Cloud Oracle Cloud Infrastructrure Oracle Tools 

OCI CLI: Query By Tags

March 18, 2020March 18, 2020 cruepprich bash, cli, cloud, oracle, query, search, shell, tags

Tagging your resources is a must. Not only for billing purposes, but also for staying organized and knowing who to

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 DevOps Oracle Developement Oracle Tools 

OCI Command Line Interface (CLI) Basics

July 16, 2018 cruepprich

The OCI Command Line Interface (CLI), is a Python-based command line interpreter, that lets you interact with the Oracle Cloud

Read more
Oracle Application Express (Apex) Oracle Developement Oracle Tools PL/SQL 

SQL Developer SSH connection

April 21, 2016 cruepprich cloud, ssh

If you have to access databases that can only be reached through SSH connections, you can configure SQL Developer (4.1)

Read more
Oracle Application Express (Apex) Oracle Developement Oracle Performance Oracle Tools PL/SQL 

SQLd360 v3 now available, new features and (hopefully) less bugs!

February 27, 2015 cruepprich

SQLd360 v3 now available, new features and (hopefully) less bugs!.

Read more
Oracle Developement Oracle Performance Oracle Tools PL/SQL 

Meet “edb360”: a free tool that provides a 360-degree view of an Oracle database

February 20, 2014 cruepprich optimization, oracle, performance, plsql, tuning

Meet "edb360": a free tool that provides a 360-degree view of an Oracle database.

Read more
Oracle Application Express (Apex) Oracle Developement Oracle Tools 

Excel Style Row Numbering in SQL

February 3, 2014 cruepprich apex, application express, connect by, hierarchy, level, oracle, pl/sql, plsql, row numbering, sql

Here is a trick to change your rownumbering (or any other sequential numbering) to the way Excel names their columns.

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