Re: How i can do a recursive sql query

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Sun, 12 Jul 1998 04:38:43 GMT
Message-ID: <6o9ekh$3pm@bgtnsc03.worldnet.att.net>

On Fri, 10 Jul 1998 15:17:47 -0400, "Ronald Berube" <Berube.ronald_at_tourisme.gouv.qc.ca> wrote:

>I would like to know how i can do a recurvie sql.

I've only done it once or twice just to try it out, but Oracle does have a CONNECT BY clause that you can use in a SELECT statement. It does just what you want. I'm way too tired right now to work up an example, but you should be able to read about it in the Server SQL Reference.

If you don't have the manual, or still have trouble, send me an email and I'll write up an example for you when I'm a bit more awake.

Jonathan Received on Sat Jul 11 1998 - 23:38:43 CDT