Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: LONG & VARCHAR2 ?
In article <stapimm1l9mtdc_at_corp.supernews.com>,
"Matt B." <mcb_at_fightspam.sd.znet.com> wrote:
> "Chris Chi" <stvllium_at_ms18.hinet.net> wrote in message
> news:8r1ct4$2if_at_netnews.hinet.net...
> > sSelectedFields VARCHAR2(4000);
> > sSQLCommand VARCHAR2(4000);
> > sAnotherSQLCommand VARCHAR2(4000);
> > sOtherFields VARCHAR2(4000);
>
> Just as a FYI (slightly off topic):
>
> VARCHAR2 has a limit of 2000 as a column in a table Oracle 7, 4000 as
a column
> in a table in Oracle 8, but as a PL/SQL variable I believe it can be
up to
> 32767 in either case.
>
> -Matt
>
>
LONG variables can only contain 32,760 bytes in PL/SQL, seven bytes shorter than a VARCHAR2. However a RAW type in PL/SQL can contain 32,767 bytes; the LONG RAW can only contain 32760 ( a restriction, I suspect, of the implementation of LONG in PL/SQL ).
-- David Fitzjarrell Oracle Certified DBA Sent via Deja.com http://www.deja.com/ Before you buy.Received on Thu Oct 19 2000 - 17:04:05 CDT
![]() |
![]() |