Re: ORA-01437: cannot have join with CONNECT BY

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Wed, 10 Sep 2003 22:46:32 +0100
Message-ID: <bc6vlvsquqt4b05o0npuqj9gqaneh3o03b@4ax.com>

On 10 Sep 2003 14:34:59 -0700, wizofoz2k_at_yahoo.com.au (Noons) wrote:

>> ORA-01437: cannot have join with CONNECT BY
>
>No, you can't. At least not in 8i. Dunno about 10, though.

You don't even have to wait that long.. 9i's got various improvements to CONNECT BY including allowing joins, the 'order siblings by' clause, and sys_connect_by_path().

--
Andy Hassall (andy@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

Received on Wed Sep 10 2003 - 16:46:32 CDT