Christoph's 2 Cents - Page 2 of 20 - A backup for my brain.

OCI Commandline Interface (CLI) Filtering

September 6, 2018October 14, 2018 cruepprich 0 Comments

In my previous CLI post, I went over some of the basics of getting started with the command line client

Cloud DevOps Oracle Developement Oracle Tools

OCI Command Line Interface (CLI) Basics

July 16, 2018July 16, 2018 cruepprich 0 Comments

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

Uncategorized

Swim Across America

July 13, 2018July 13, 2018 cruepprich 0 Comments

For the third time, I’ll be joining the Swim Across America fundraiser for cancer research. I know that many families

DevOps docker Linux Oracle Developement

ORA-12545 When running Oracle inside Docker

July 11, 2018 cruepprich 0 Comments devops, docker, oracle, oracle xe

When trying to make an http request from my Oracle database running inside a Docker container, I received the following error:

Oracle Developement

Building a Oracle 12.2 Docker Image

July 5, 2018July 5, 2018 cruepprich 0 Comments

…or a 12.2…or a 11.2 image… Docker installation instructions for RHEL 7. To quickly build an Oracle database Docker image, you

Oracle Developement

Reblog: Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7

March 29, 2018 cruepprich 0 Comments

Here is a nice guide for a full-stack APEX configuration: http://dsavenko.me/oracledb-apex-ords-tomcat-httpd-centos7-all-in-one-guide-introduction/

Oracle Developement

Quick & Dirty: Populate number array from string.

March 13, 2018June 20, 2018 cruepprich 0 Comments

Here is a quick way to convert a list of colon separated numbers into a number array:

declare 
  l_list_of_numbers varchar2(32767) := '1:2:3'; 
  l_string_array apex_application_global.vc_arr2; 
  l_number_array apex_application_global.n_arr; 
begin 
  l_string_array := apex_util.string_to_table(l_list_of_numbers); 
  select * bulk collect 
  into   l_number_array 
  from   table(l_string_array); 
   
  for idx in 1..l_number_array.count 
  loop 
    dbms_output.put_line(l_number_array(idx)); 
  end loop; 
end;