CLOB转成字符串

DBMS_LOB.substr(t.clob_fild,6000,1)
例如：select DBMS_LOB.substr(t.clob_fild,6000,1) from tab

字符串转成BLOB

TO_BLOB(UTL_RAW.CAST_TO_RAW(Str))