oracle验证blob字段是否为空

select count(*) from api_xml where dbms_lob.getlength(XML_CONTENT)=0;判定Blob型字段是否为空，效率不高。

select count(*) from api_xml where dbms_lob.getlength(XML_CONTENT)=0;