Re: size limitation in a query

In article <C9ApOKDHBTJab2ld++RAR=3AZC05_at_4ax.com>,   tkyte_at_us.oracle.com wrote:
> A copy of this was sent to Ron <ron168_at_yahoo.com>
> (if that email address didn't require changing)
> On Wed, 10 Nov 1999 12:54:37 -0500, you wrote:
>
> >What is the maximum size(length) of a query statement for a single
line
> >or multiple lines...that Oracle can handle?
>
> From the limits section of the reference manual:
>
> SQL Statement Length
>
> maximum length of statements 64K maximum;
>
> particular tools may impose lower limits
>
> ====================================================
>
> sqlplus for example imposes a max line length of about 255 characters
(need a
> newline before 255) but lets you use a line continuation character to
glue >1
> line together.
>
> other tools = different limits.
>
> --
> See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to
Oracle8i'...
> Current article is "Part I of V, Autonomous Transactions" updated June
21'st
>
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries Reston, VA USA
>
> Opinions are mine and do not necessarily reflect those of Oracle
Corporation

Tom,

I've not come near this limit but it does bring to mind a question: Does ORACLE strip the excess whitespace (e.g., newlines, trailing spaces)? How does this affect the reuse of the query (i.e., when the parser checks to see if it's done this one before)?

Just curious.

   ed

--
Ed Prochak
Magic Interface, Ltd.
ORACLE Development, conversions, training and support 440-498-3700 magic_at_interfacefamily.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 11 1999 - 11:57:44 CST