RE: limit on number of tables in join
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'chris@xxxxxxxxxxxxxxxxxxxxx'" <chris@xxxxxxxxxxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 29 Apr 2005 09:32:20 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Chris Dunscombe
Sent: Friday, April 29, 2005 2:21 AM
To: ranko.mosic@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx>:
> What is it ?=20
> Also what is max size of sql query ?=20
>
> Thanks, Ranko.
> --
> //www.freelists.org/webpage/oracle-l
>
Chris Dunscombe
www.christallize.com
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
