Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Size of a LONG
I think I recall it is different for a table -- 5000 maybe but my memory
fails me -- than for a statement or stored proc which would be
varchar2(2000) -- anyway under 7.3, there are problems with stored procs
if they are longer than 2000
in v.8 I hear LOB's work fine
Chris Forlano wrote:
>
> Any idea how to determine how much data is contained in a LONG?
>
> Something like:
>
> select length(description) from test;
>
> Thanks,
>
> Chris
>
> --
> Chris Forlano
> Automation Development
> Nortel Networks, Maidenhead
> 590 4342 (01628 434 342)
> cforlano_at_nortelnetworks.com
Received on Fri Nov 19 1999 - 23:01:17 CST