select decode(tab,1,a),decode(tab,2,a),decode(tab,3,a),decode(tab,4,a) from( select count(*) a,1 tab from a union all select count(*) ,2 from b union all select count(*) ,3 from c union all select count(*) ,4 from d)
试试 select num_rows from all_tables where owner = ... and table_name in(....)
select count(*) a,1 tab from a
union all
select count(*) ,2 from b
union all
select count(*) ,3 from c
union all
select count(*) ,4 from d)
select num_rows
from all_tables
where owner = ...
and table_name in(....)
select table_name,num_rows from user_tables