오라클 XML 쿼리

오라클 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'
;