Re: Query Length in Oracle.

From: John Higgins <JH33378_at_deere.com>
Date: Thu, 20 May 1999 15:02:18 -0500
Message-ID: <37446A49.ECFA4819@deere.com>

The maximum length SQL statement in Oracle 7 is 64K. I don't know if this changed in Oracle 8.

Chittesh Mehta wrote:

> Hi,
>
> Does anyone has Idea what is the Maximum Query lenth can be parsed and
> executed by Oracle.
> (I mean length of SQL Statement)
>
> We have got some big queries and getting some problems with that..getting
> parsing
> error.
>
> Thanks in Advance.
>
> - Chittesh
Received on Thu May 20 1999 - 15:02:18 CDT

This message: [ Message body ]
Next message: Finn Ellebaek Nielsen: "Re: TNSlistener service problem in Oracle8 on Win2000 beta3"
Previous message: Darren Brock: "Re: Web/DB Development Tools?"
In reply to: Chittesh Mehta: "Query Length in Oracle."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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