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 more
Author: cruepprich
Building 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
Downloading Oracle Files With the Command Line
Here is a quick trick that allows you to download files from OTN through the command line. In order to
Read more12 Things Developers Will Love in 12.2
This is a reblog from Chris Saxon: https://blogs.oracle.com/sql/12-things-developers-will-love-about-oracle-database-12c-release-2
Read moreGetting started with Liquibase
Liquibase is a source code control management tool for database schemas. It basically consists of a command line tool that
Read moreReset Password By Values in 12c
In prior Oracle version you used to be able to hack a users password by using the identified by values
Read moreGetting to Grips with the APEX Interactive Grid API
Matt Mulvaney has an excellent post regading the APEX interactive grid: http://www.explorer.uk.com/getting-grips-apex-interactive-grid-api/
Read moreIdentity Columns and Data Pump
via Identity Columns and Data Pump
Read more