Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: LONG & VARCHAR2 ?
"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