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

From: <hlh_nospam_at_excite.com>
Date: Thu, 15 Apr 1999 23:01:05 GMT
Message-ID: <7f5r3d$dgk$1@nnrp1.dejanews.com>

In article <7f525b$ml1$1_at_nnrp1.dejanews.com>, Eduardo Pimenta <epimenta_at_my-dejanews.com> wrote:
> In article <7f0g1r$qfc$1_at_nnrp1.dejanews.com>,
[snip]
> This line should read CONNECT BY PRIOR psf_part = psf_assy
[snip]

Actually, (as pointed out by another poster) the line should have been:

CONNECT BY psf_assy = PRIOR psf_part

Which does the treewalk in the correct direction. I though the direction was determined by whether the PRIOR was there or not, and Oracle didn't complain -- it just gave the wrong answer when I left it out. The Oracle documentation was nearly opaque on this subject.

--
Howard Lee Harkness

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