Re: Limitation in Oracle query ?

From: Spencer <spencerp_at_swbell.net>
Date: Tue, 30 Jan 2001 23:18:06 -0600
Message-ID: <7eNd6.480$nD1.9554@nnrp1.sbc.net>

yes, there are limits on the number of objects that can be referenced in a single SQL statement.

<placroix195_at_my-deja.com> wrote in message news:956hmf$rp$1_at_nnrp1.deja.com...
> In T_SQL, the maximum number of tables is allowed in a query is 256.
> Does anyone knows if there is such a limitation with Oracle and what is
> this maximum for Oracle ?
> Is there a limitation for queries on views ?
>
> Thanks.
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Tue Jan 30 2001 - 23:18:06 CST