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

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

Re: LONG & VARCHAR2 ?

From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: Fri, 29 Sep 2000 21:09:03 -0700
Message-ID: <stapimm1l9mtdc@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 Fri Sep 29 2000 - 23:09:03 CDT

Original text of this message

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