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

pile of stones on shore

Oracle Developement PL/SQL

Hierarchical Query: Roll-up leaf nodes to ancestors.

June 26, 2015September 18, 2023 cruepprich query, sql

This query may be more applicable to a bill of materials type of query. I’ve added a new column 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