From oracle-l-bounce@freelists.org Fri Apr 29 02:25:43 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3T7PhiD015847 for ; Fri, 29 Apr 2005 02:25:43 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j3T7Ph4Z015843 for ; Fri, 29 Apr 2005 02:25:43 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 39B17189C6C; Fri, 29 Apr 2005 01:23:14 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26395-05; Fri, 29 Apr 2005 01:23:14 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AC3AF188838; Fri, 29 Apr 2005 01:23:13 -0500 (EST) Message-ID: <1114755682.4271d2624a13c@webmail.christallize.com> Date: Fri, 29 Apr 2005 07:21:22 +0100 From: Chris Dunscombe To: ranko.mosic@gmail.com Cc: oracle-l@freelists.org Subject: Re: limit on number of tables in join References: <367369f105042808514b89587a@mail.gmail.com> In-Reply-To: <367369f105042808514b89587a@mail.gmail.com> MIME-Version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.3 X-Originating-IP: 194.9.188.22 X-archive-position: 19177 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: chris@thedunscombes.f2s.com Precedence: normal Reply-To: chris@thedunscombes.f2s.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.63 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 : > 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