Oracle has a more succinct syntax for this known as the CONNECT BY clause for a select. It is used to extract an explained query from a plan table. It does se

Oracle has a more succinct syntax for this known as the CONNECT BY clause for a select. It is used to extract an explained query from a plan table. It does seem to be much easier than a common table expression.