oracle clob where

来源:互联网 发布:广东奥飞数据科技ipo 编辑:程序博客网 时间:2024/06/05 05:26

select count(*) from AUTOPHONECALL where CALLSTATE=1 and callid<>0 and CONTENTTYPE<>'外部语音' 

and (dbms_lob.instr(AUTOPHONECALL.phonelist, '026699999', 1, 1) > 0
or  dbms_lob.instr(AUTOPHONECALL.phonelist, '026699999', 1, 1) > 0

or  dbms_lob.instr(AUTOPHONECALL.phonelist, '13902919999', 1, 1) > 0)



以上是进行了三个电话号码的模糊查询

1 0
原创粉丝点击