RE: limit on number of tables in join

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Fri, 29 Apr 2005 09:32:20 -0400
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF41050395B898@usahm236.amer.corp.eds.com>

Oracle has supported a 64K limit for an SQL statement from at least version 7.0 through 9.2. You can find this limit in the Oracle 9.2 Reference manual chapter on Limits under Logical Database Limits.

HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Chris Dunscombe
Sent: Friday, April 29, 2005 2:21 AM
To: ranko.mosic_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: limit on number of tables in join

I believe the SQL statement limit is 32 KB for Oracle 9i but check it out in the manuals (Server Ref or SQL Ref). Also this is something that could well be version specific.

Anyway I hope I never need a statement anywhere near 32 KB!!

Cheers,

Chris

Quoting Ranko Mosic <ranko.mosic_at_gmail.com>:

> What is it ?=20
> Also what is max size of sql query ?=20
>
> Thanks, Ranko.
> --
> http://www.freelists.org/webpage/oracle-l
>

Chris Dunscombe

www.christallize.com

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 29 2005 - 09:47:41 CDT