select utl_raw.cast_to_varchar2 (dbms_lob.substr (clume_name)) from tab1 ; --将clob字段显示为字符串
获取blob字段长度 DBMS_LOB.GETLENGTH(COLUMN)
select utl_raw.cast_to_varchar2 (dbms_lob.substr (clume_name)) from tab1 ; --将clob字段显示为字符串
获取blob字段长度 DBMS_LOB.GETLENGTH(COLUMN)