Re: SQL string length maximum

From: Monty <mmontreaux_at_hotmail.com>
Date: 27 Nov 2002 14:32:06 -0800
Message-ID: <6284dd3.0211271432.4f597e90@posting.google.com>

Sorry I wasn't clear.

I meant the length of an SQL string, ie what is the maximum length of a "SELECT * WHERE A=B AND C=D AND E=F AND EXISTS (SELECT .........." etc

Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3DE29147.7D3F4EB3_at_exesolutions.com>...
> Monty wrote:
>
> > Excuse such a simple question but is there a limit on the number of
> > characters that an SQL string can contain and if so, what is it (using
> > Oracle9i personal).
> > Thank you
> > Monty
>
> In a table 4K. In a variable 32K.
>
> Assuming you are talking about VARCHAR2.
>
> If you are talking about CLOBs then 4GB.
>
> Daniel Morgan
Received on Wed Nov 27 2002 - 16:32:06 CST