Re: help on start with and connect by with parameter

[...]
>This is the syntax that i'm using
>
>select child
>FROM tableX
>START WITH (father) = &akey or &akey=0
>CONNECT BY father = PRIOR child
>
>Without the &akey=0, it's working. But with the 0, it doesn't show
>anything.
>
>Please help me. Thanks

Hi,

I've tested your case just now. It works fine. The only change I've applied is CONNECT BY PRIOR father = child. May be you missed some details in your posting?

Regards,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com