Re: LONG & VARCHAR2 ?
From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: Fri, 29 Sep 2000 21:09:03 -0700
Message-ID: <stapimm1l9mtdc_at_corp.supernews.com>
Date: Fri, 29 Sep 2000 21:09:03 -0700
Message-ID: <stapimm1l9mtdc_at_corp.supernews.com>
"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 Received on Sat Sep 30 2000 - 06:09:03 CEST