Reblog: 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 moreORDS REST Modules with PL/SQL
Here is one of the best references I’ve found for creating ORDS REST services with PL/SQL. https://oracle-base.com/articles/misc/oracle-rest-data-services-ords-create-basic-rest-web-services-using-plsql#create-post-web-services There are examples
Read moreODTUG GeekAThon 2017
This year, ODTUG sponsored another GeekAThon, challenging nerds to come up with cool ideas using Bluetooth Low Energy beacons. Here
Read more