Nice. A few tricks with dual I haven't come across before.

When you get into examples using tables it would be nice if you provided the table definitions and some sample data.

PS: psoug's connect by page (http://psoug.org/reference/connectby.html) is my favorite reference.