Re: Connect By Woes

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 22 Jul 1999 15:37:59 +0100
Message-ID: <932654576.5586.0.nnrp-04.9e984b29@news.demon.co.uk>

The following predicate works on 8.1.5, and I have always assumed it worked anyway on 7 (but haven't checked).

connect by

p_col1 = prior col1
and p_col2 = prior col2

or in your case

connect by

PARENT_ID = PRIOR SELF_ID
and PREVIOUS_ID = PRIOR SELF

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Howard Lee Harkness wrote in message
<3DE1620F55F92721.911EA3E0C2E61B80.9988ACB3DEFF012E_at_lp.airnews.net>...
>On Sat, 17 Jul 1999 04:55:23 GMT, Martin Douglas
><Martin.Douglas_at_Boeing.com> wrote:
>
>>Does anyone know if Oracle 8.1.5 has extended CONNECT BY to something
>>like...
>>
>> CONNECT BY (PARENT_ID = PRIOR SELF_ID, PREVIOUS_ID = PRIOR SELF, ...)
>
Received on Thu Jul 22 1999 - 09:37:59 CDT