Hierarchical Query revisited

From: Wolfgang Hann <W.Hann_at_netway.at>
Date: 1998/04/03
Message-ID: <01bd5ee9$608baf80$0601030a@ENTWICKLUNG.NETWAY.AT>#1/1

Anybody of you has or had the problem to follow one branch of a hierarchical structure beginning from the leaf object.

The problem is that connect by.... can only show you the complete tree. In addition it allows you only to start your query from the parent.

I´ve solved this one very unnicely by using a Cursor Open/Close Loop which works but
i don´t think is the fastest one.

Any ideas?

If not i strongly suggest that Oracle should consider enhancing their hierarchical query features. Received on Fri Apr 03 1998 - 00:00:00 CST