Re: avg/max of a LONG

From: RC <rclarence_at_tyc.com>
Date: Thu, 30 Mar 2000 22:32:17 GMT
Message-ID: <se7lfhuani7130@corp.supernews.com>

Long data unfortunately has to be manipulated with a 3GL or through the Oracle OCI API. Its very annoying so I suggest you use CLOB or BLOB object types if possible because Oracle has defined functions to act on those datatypes.

HTH
RC
Stephen Wells wrote:
>
>
> how do I find/estimate the average and max length of a LONG column on a
> table.
>
> I tried all the standard vsize,avgsize,lenght...ect and none work on a
LONG?
>
> I am now searching the FAQ's.....
>
> Thanks for any info
> Stephen
>
>
>
>
>

--
Posted via CNET Help.com
http://www.help.com/ Received on Thu Mar 30 2000 - 16:32:17 CST