Monthly Archives: March 2011

Analytic vs Hierarchical

While playing around with Analytic functions with a Hierarchical function in my query I stubled upon some strange behaviour I cannot explain (yet). The documentation provided by Oracle states the following: Analytic functions are the last set of operations performed in a query except for the final ORDER BY clause. Right, that would mean I […]

Read more


If you have ever tried to implement a requirement that implies that either one field is filled, or the other one but not both and not both not then you might have thought about using an XOR function. Unfortunately this is not implemented in Oracle SQL.

Read more