connect by – Christoph's 2 Cents

Oracle Application Express (Apex) Oracle Developement Oracle Tools

Excel Style Row Numbering in SQL

February 3, 2014 cruepprich 0 Comments apex, application express, connect by, hierarchy, level, oracle, pl/sql, plsql, row numbering, sql

Here is a trick to change your rownumbering (or any other sequential numbering) to the way Excel names their columns.

Read more

Oracle Developement PL/SQL

Find ancestor from hierarchy

October 2, 2013 cruepprich 4 Comments apex, connect by, grand parent, hierarchical, hierarchy, oracle, parent, pl/sql, plsql, query, reports, sql, traverse

I needed to find a quick way to select a particular ancestor for a child in a hierarchical table. For

Read more