Db/Oracle
쿼리 내용으로 쿼리실행
seongsland
2013. 6. 5. 18:46
테이블들의 카운터를 가져올때 유용
select
table_name,
to_number(
extractvalue(
xmltype(
dbms_xmlgen.getxml('select count(*) c from '||table_name))
,'/ROWSET/ROW/C')) count
from user_tables
ORDER BY TABLE_NAME
출처 : 여우구름(http://m.blog.naver.com/lovzip/20185117406)
select
table_name,
to_number(
extractvalue(
xmltype(
dbms_xmlgen.getxml('select count(*) c from '||table_name))
,'/ROWSET/ROW/C')) count
from user_tables
ORDER BY TABLE_NAME
출처 : 여우구름(http://m.blog.naver.com/lovzip/20185117406)