Re: START WITH, CONNECT BY Compatibility

From: VC <boston103_at_hotmail.com>
Date: Sun, 22 May 2005 19:48:09 -0400
Message-ID: <Fpadndeq2YazhwzfRVn-rA@comcast.com>

Hi,

"ashley" <none_at_gmeail.com> wrote in message news:4290e50c$1_1_at_rain.i-cable.com...
> Apart from Oracle, which databases support the "start with" and "connect
> by"
> clauses for hierarchical query? Does MySQL and MSSQL support them? Are
> their syntax portable with Oracle? I just need to evaluate this before
> using these clauses in my oracle application - for portability concern.
>
>

They are Oracle specific. DB2 has WITH ... UNION ALL (a recursive query with different semantics), SQL Server has nothing of the kind. Yukon will have the same as DB2.

DB2's recursive query is SQL-99 compliant, Oracle's is proprietary. Received on Sun May 22 2005 - 18:48:09 CDT