17,086
社区成员
发帖
与我相关
我的任务
分享
--mysql
select count(*) as col_0_0_ from score_news_online scorenewso0_ where scorenewso0_.onlineFlag=1 and trim(unhex(hex(scorenewso0_.oneTitle)))=trim(unhex('D5AEC8A8')) and scorenewso0_.newsType='news_sc_newstype_yxdt' and (scorenewso0_.assTitle between '10000000' and '50000000')
--oracle
select count(*) as col_0_0_ from bp_winner_ticketphoto scorenewso0_ where convert(UTL_RAW.CAST_TO_VARCHAR2(scorenewso0_.photodata), 'utf8', 'zhs16gbk')='债权'
and scorenewso0_.newsType='news_hub_newstype_yxdt' and (scorenewso0_.assTitle between '10000000' and '50000000')
SQL> select UTL_RAW.CAST_TO_VARCHAR2(a) from t_blob t ;
UTL_RAW.CAST_TO_VARCHAR2(A)
--------------------------------------------------------------------------------
中国
SQL> select UTL_RAW.CAST_TO_VARCHAR2(a) from t_blob t where UTL_RAW.CAST_TO_VARCHAR2(a)='12321';
UTL_RAW.CAST_TO_VARCHAR2(A)
--------------------------------------------------------------------------------
12321
SQL>