Factorial in Oracle SQL – using both new Recursive Subquery and classic Connect By approach
I regularly teach a masterclass on Oracle SQL. One of the topics I explore in depth is the use of the CONNECT BY query style to perform not just …
Tag: connect by
The Knight's Challenge – Recursive SQL Queries make a move on the Chess board
In my quest to position ‘connect by’ (and its 11g successor, Recursive Subquery) as mechanism for recursive queries rather than just an hierarchical query facility, I stumbled across a …
Anti-Search patterns – SQL to look for what is NOT there – Part Two
It is a strange thing really: querying the database to find missing data. Queries usually report on what is there. Not the queries in this article (and its prequel): …
Oracle 11gR2 – alternative for CONNECT_BY_ISLEAF function for Recursive Subquery Factoring (dedicated to Anton)
On our blog, we have been discussing the new hierarchical query functionality in Oracle Database 11g Release 2, using Recursive Suquery Factoring. Instead of using CONNECT BY and its …
Oracle RDBMS 11gR2 – new style hierarchical querying using Recursive Subquery Factoring
![Oracle RDBMS 11gR2 – new style hierarchical querying using Recursive Subquery Factoring]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Oracle RDBMS 11gR2 – new style hierarchical querying using Recursive Subquery Factoring")
Oracle Database 11g Release 2 introduces the successor to the good old Connect By based hierarchical querying, called Recursive Subquery Factoring. The basics are described in a previous …
Oracle RDBMS 11gR2 – goodbye Connect By or: the end of hierarchical querying as we know it
Many years ago, Oracle basically set the standard in SQL. Whatever was Oracle SQL could be seen as the standard. This has never been absolutely true – ANSIÂ SQL was …