Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: limit on number of tables in join

Re: limit on number of tables in join

From: Chris Dunscombe <chris_at_thedunscombes.f2s.com>
Date: Fri, 29 Apr 2005 07:21:22 +0100
Message-ID: <1114755682.4271d2624a13c@webmail.christallize.com>


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
Received on Fri Apr 29 2005 - 02:25:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US