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 More
Christoph's 2 Cents
A Backup for My Brain!
Oracle Developement
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 MoreSSH Login Without Password
Quick instructions on how to setup SSH login without password: http://www.linuxproblem.org/art_9.html
Read MoreUpgrading to Application Express 5.0 in Your Oracle Database Release 12.1 Multitenant Container Database (CDB)
This is a reblog from Jason Straub’s blog Application Express Nuggets, discussing how to upgrade APEX in CDB$ROOT of your
Read MoreOracle 12c Developer Days VM
Get OS authentication to work with the Dev. Days VM Reblogged from Stojan’s Oracle Blog.
Read More