it supports both versions: start before connect and vice versa.
regards,
---
.evgen
On Tue, 26 Nov 2002, Fernando Nasser wrote:
> The syntax below is wrong. Oracle has:
>
> [START WITH condition] CONNECT BY condition
>
> not the reverse as stated below. Maybe this was just a documentation mistake (I
> haven't looked at the code).
>
> Fernando
>
> Evgen Potemkin wrote:
> > +
> > + Syntax.
> > +
> > + SELECT ... FROM ... [ WHERE condition ] CONNECT BY c_expr PRIOR c_expr START WITH expr
> > + [ HAVING condition [, ...]] [ LIMIT ... ] [ OFFSET ... ]
> --
> Fernando Nasser
> Red Hat - Toronto E-Mail: fnasser@redhat.com
> 2323 Yonge Street, Suite #300
> Toronto, Ontario M4P 2C9
>
>