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(at)redhat(dot)com
2323 Yonge Street, Suite #300
Toronto, Ontario M4P 2C9