判断blob字段是否为空

判断字段col是否为空或者是empty_blob()

select *  from table1
 where col is null or dbms_lob.compare(col, empty_clob()) = 0