Hierarchical Query: Roll-up leaf nodes to ancestors.
This query may be more applicable to a bill of materials type of query. I’ve added a new column to
Read moreMonth: June 2015
Hierarchical Query: Get the ancestors in top down order
This query starts with the leaf node and climbs up the hierarchy to the top ancestor. It then displays the
Read moreAPEX 5: JavaScript Debugging
Here is a re-blog of Matt Mulvaney’s post about debugging JavaScript in Oracle APEX 5: http://www.explorer-development.uk.com/javascript-debugging-apex-5-last/
Read moreORDS 3 – Enabling RESTful service for database tables
We’ll take a look at how to enable a RESTful service in ORDS 3.0 via PL/SQL, and how to retrieve
Read moreReblog: Oracle Responsive Email Templates
Vincent Morneau has done a fantastic job of creating responsive email templates for Oracle: http://vmorneau.me/oracle-rwd-email-template-api/
Read moreAPEX 5: Packaged Application Icons
To use some of the packaged application icons for your own applications, include the packaged apps css file in your
Read moreAPEX 5: Convert Skillbuilder’s Modal to Universal Theme
If you have implemented the Skillbuilder’s Modal Page Plugin in an application of a previous version of APEX, and want
Read more