Re: Calculating the size of a Long column
- From: Charlotte Hammond <charlottejanehammond@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 19 Aug 2005 02:02:13 -0700 (PDT)
Hi Chris,
Would something like this work?
declare
v_longest integer := 0;
begin
for x in (select longcolumn from table)
loop
if length(x.longcolumn) > v_longest then
v_longest := length(x.longcolumn);
end if;
end loop;
dbms_output.put_line(v_longest);
end;
/
Charlotte
>>
>>
>>
Chris Dunscombe <chris@xxxxxxxxxxxxxxxxxxxxx
>>>Sent by: oracle-l-bounce@xxxxxxxxxxxxx
>>19/08/2005 08:34
>>Please respond to chris
>>
>> To: Oracle-L <oracle-l@xxxxxxxxxxxxx
>>> cc:
>> Subject: Calculating the size of a Long column
>>
>>
>>I've a largish table (24 GB) with a long column. I'd
like to convert it to a
>>varchar2 (easier to use than a CLOB) as I believe
that the data stored in the
>>long isn't actually very long.
>>
>>However I don't know of an easy way (I could use
Perl/Python/PLSQL etc and
>>select the col in every row and do a length of the
resulting strings) to
>>calculate the max size for the long col given I
can't use vsize 'cos it's a
>>long of course. Any ideas?
>>
>>BTW it's 8.1.7 on HP
>>
>>Thanks,
>>
>>Chris Dunscombe
>>
>>www.christallize.com
>>--
>>//www.freelists.org/webpage/oracle-l
>>
>>
>>
>>
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
--
//www.freelists.org/webpage/oracle-l
Other related posts:
