Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: START WITH, CONNECT BY Compatibility
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