1.存数据进去的时候要用rawtohex
insert into l_raw values (rawtohex('aaa'));
2.直接to_lob查询报错select to_lob(dat1) from l_raw
3.可以创建一个临时表,这个字段to_lob就没有问题
CREATE TABLE l_raw2 AS
SELECT TO_LOB(dat1) AS dat1
FROM l_raw
4.再用 utl_raw.cast_to_varchar2 函数就没有问题了(直接在long raw 上面用改函数报错)
select utl_raw.cast_to_varchar2(CONTENT) rr from l_raw1