Terraform: About Variables
As a supplemental article to Terraforming the Oracle Cloud Infrastructure – Part 1, I want to say a few words about
Read moreAuthor: cruepprich
Oracle Magazine: Voice Assistants
Here is a reblog of an Oracle Magazine article for which I was interviewed:https://blogs.oracle.com/oraclemagazine/hey%2c-data-experts%3a-voice-assistants-are-calling-your-name
Read moreOCI Commandline Interface (CLI) Filtering
In my previous CLI post, I went over some of the basics of getting started with the command line client
Read more
Terraforming the Oracle Cloud Infrastructure – Part 1
When you begin working with the Oracle Cloud Infrastructure (OCI), or any other cloud provider, you soon notice that creating
Read more
OCI Command Line Interface (CLI) Basics
The OCI Command Line Interface (CLI), is a Python-based command line interpreter, that lets you interact with the Oracle Cloud
Read more
Swim Across America
For the third time, I’ll be joining the Swim Across America fundraiser for cancer research. I know that many families
Read more
ORA-12545 When running Oracle inside Docker
When trying to make an http request from my Oracle database running inside a Docker container, I received the following error:
Read moreBuilding a Oracle 12.2 Docker Image
…or a 12.2…or a 11.2 image… Docker installation instructions for RHEL 7. To quickly build an Oracle database Docker image, you
Read moreReblog: Oracle Database XE, APEX, ORDS, Tomcat and httpd on CentOS 7
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/
Read moreQuick & Dirty: Populate number array from string.
Here is a quick way to convert a list of colon separated numbers into a number array:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
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; |
Read more