to_number(extractvalue~~!!)

select table_name, to_number(extractvalue(xmltype(dbms_xmlgen.getxml(‘select count(1) c from ‘||owner||’.’||table_name)),’/ROWSET/ROW/C’)) as count
from all_tables
where table_name like ‘%M40%’
;

테이블리스트를 가지고 테이블컬럼수를 가져오는 쿼리

Leave a Reply

Your email address will not be published.