UTL_RAW.CAST_TO_VARCHAR2 (
r IN RAW)
RETURN VARCHAR2;
select * from tablename where upper(utl_raw.cast_to_varchar2(fieldname)) like '%3131%'
r IN RAW)
RETURN VARCHAR2;
select * from tablename where upper(utl_raw.cast_to_varchar2(fieldname)) like '%3131%'
RETURN VARCHAR2;
应放在哪里的?如直接执行
select * from tablename where upper(utl_raw.cast_to_varchar2(fieldname)) like '%3131%'
当fieldname为 long raw 类型时,系统会报“非法使用LONG数据类型”;
如果fieldname为 raw 类型时,则无语法错误。
本人对SQL不熟,还请多多指点!