Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL string length maximum
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 Mon Nov 25 2002 - 15:08:32 CST