判断字段col是否为空或者是empty_blob()
select * from table1
where col is null or dbms_lob.compare(col, empty_clob()) = 0
select * from table1
where col is null or dbms_lob.compare(col, empty_clob()) = 0