Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: LONG & VARCHAR2 ?

Re: LONG & VARCHAR2 ?

From: <oratune_at_aol.com>
Date: Thu, 19 Oct 2000 22:04:05 GMT
Message-ID: <8snr4h$oo8$1@nnrp1.deja.com>

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

Original text of this message

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