Re: Traversing a Tree Structure in Pro*C

From: Dave Mausner <dlm_at_dlogics.dlogics.com>
Date: Mon, 30 Aug 1993 22:30:43 GMT
Message-ID: <930830163043_at_dlpc030.dlogics.com>


brooks_at_usiva.com (Lyle D. Brooks) writes:

> I'd like to know if anyone has had experience using Pro*C to
> recursively traverse a data structure (such as tree) in Oracle.

You can do this using CONNECT BY ... START WITH syntax, which is easier than opening a new cursor at each node as you descend.

--
Dave Mausner / Sr Consultant / Datalogics division of Frame Technology Inc
Received on Tue Aug 31 1993 - 00:30:43 CEST

Original text of this message