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