Oracle Developement

Here is a quick way to convert a list of colon separated numbers into a number array: declare l_list_of_numbers varchar2(32767)

Here is a quick trick that allows you to download files from OTN through the command line. In order to

This is a reblog from Chris Saxon: https://blogs.oracle.com/sql/12-things-developers-will-love-about-oracle-database-12c-release-2  

Liquibase is a source code control management tool for database schemas. It basically consists of a command line tool that

In prior Oracle version you used to be able to hack a users password by using the identified by values

Matt Mulvaney has an excellent post regading the APEX interactive grid: http://www.explorer.uk.com/getting-grips-apex-interactive-grid-api/  

via Identity Columns and Data Pump

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

This year, ODTUG sponsored another GeekAThon, challenging nerds to come up with cool ideas using Bluetooth Low Energy beacons. Here

To prevent unauthorized access to your REST modules, APEX provides an easy, declarative way of adding basic authentication. This method