The following syntax returns the length of data within a field, whether the field is a CLOB or not:


select LENGTH(eo.eo_data) as eo_data_num from EO