다른 명령
오라클 XML 쿼리
테이블 건수 조회
SELECT A.OWNER,A.TABLE_NAME , REGEXP_REPLACE(EXTRACT( dbms_xmlgen.getXmlType('SELECT COUNT(*)||'' '' C FROM '||A.OWNER||'.'||A.TABLE_NAME), '/ROWSET/ROW/C' ).getStringVal() , '<C>|</C><C>|</C>', '' -- 태그 제거 ) C1 -- , dbms_lob.substr(dbms_xmlgen.getXmlType('SELECT COUNT(*)||'','' C FROM '||A.OWNER||'.'||A.TABLE_NAME).EXTRACT('//text()').getclobval(),100,1) C2 FROM DBA_TABLES A WHERE OWNER = 'XXX' ;