原报错SQL
Where 1=1 and a.istat = 0 and ListUser='admin' order by iStat desc, sDate Desc
错误信息如下:
ORA-00932: inconsistent datatypes: expected - got CLOB
经查表结构发现该字段为clob类型
SELECT table_name, column_name, data_type,DATA_LENGTH,COLUMN_ID FROM all_tab_cols WHERE table_name =upper('b_FlowLeave')
解决方法:
在查出来字符串长度小于4000的时候可以用dbms_lob.substr(clob_column)这个oracle内置的函数进行clob转字符串操作
Where 1=1 and a.istat = 0 and dbms_lob.substr(ListUser)='admin' order by iStat desc, sDate Desc