SkyWriter, that's exactly it - it was also provided in AlanP's linked page. Thanks to both of you.
I'm having a tough time interpreting the command START WITH in this context. Does anyone have a good explanation of that concept, and why it helps deliver the data in the format I was expecting? The Oracle docs don't do a good job here.
Lets say you work in a company and each employee has a manager stored in the same table ala the Oracle tables that ship with the db.
Emp ID Mgr Id
If you wanted to find the whole chain from employee 7, you can put that in your start with clause:
start with employee_id = 7
Not sure if that made any sense on top of what Alan said - you can start anywhere in the tree, and that start with clauses determines where you start. Where you put the prior in the connect by clause determines which direction you go.