转载:https://blog.csdn.net/qq_37980551/article/details/85264988
select utl_raw.cast_to_varchar2(dbms_lob.substr(a,b,c)) from table;
a:你要转换的那个字段;b:截取字符串长度,一般限制2000;c:起始位置;
oracle 中blob大字段转string类型
原文:https://www.cnblogs.com/liguang/p/12849555.html