Re: Question on SELECT LEVEL...CONNECT BY, tree-walking

From: Eduardo Pimenta <epimenta_at_my-dejanews.com>
Date: Thu, 15 Apr 1999 15:55:28 GMT
Message-ID: <7f525b$ml1$1@nnrp1.dejanews.com>

In article <7f0g1r$qfc$1_at_nnrp1.dejanews.com>, hlh_nospam_at_excite.com wrote:
> I'm having some difficulty with SELECT LEVEL...CONNECT BY, as illustrated
> below.
>...

Reading the docs, something is missing in your select: the PRIOR before the parent condition in the CONNECT BY clause.

> listing 1
> SQL> SELECT level,
> 2 psf_find_nbr,
> 3 psf_part,
> 4 psf_assy
> 5 FROM sec_psf_effective_view
> 6 CONNECT BY psf_part = psf_assy

This line should read CONNECT BY PRIOR psf_part = psf_assy

> 7 START WITH psf_assy = '502-25700-00';
> [snip]
> 1 0016 32.1516.589-19 502-25700-00
> [snip]
> 1 0008 502-25724-00 502-25700-00
> 1 0009 502-23125-00 502-25700-00
> 1 0010 502-25797-00 502-25700-00
> [snip]
>
>...

Eduardo Pimenta.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 15 1999 - 10:55:28 CDT