query – Christoph's 2 Cents

Cloud Oracle Cloud Infrastructrure Oracle Tools

OCI CLI: Query By Tags

March 18, 2020March 18, 2020 cruepprich bash, cli, cloud, oracle, query, search, shell, tags

Tagging your resources is a must. Not only for billing purposes, but also for staying organized and knowing who to

Oracle Developement PL/SQL

Find ancestor from hierarchy

October 2, 2013March 4, 2022 cruepprich 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