Max length of a Long column

[hemanr]

Hi Gurus,

Is there any way I can find the maximum length of a LONG column?

Thanks!

[hemanr]

Found the answer in the forum itself...

This was posted by ssmith. Thanks ssmith!

create or replace procedure find_long_length is

CURSOR a1 is
SELECT col_name
FROM table_name;

vRaw number;
v_max_len number;

BEGIN
vRaw :=0;
v_max_len := 0;

FOR arec in a1 LOOP

vRaw := utl_raw.length(arec.col_name);

if vRaw > v_max_len then
v_max_len := vRaw;
end if;

END LOOP;
dbms_output.put_line('Max Length is '||v_max_len);
END;