Oracle'da Hangi Tabloda Kaç Satır Var

select t.owner, t.table_name, t.num_rows, count(*)
from all_tables t left join all_tab_columns c on t.table_name = c.table_name
where num_rows is not null
group by t.owner, t.table_name, t.num_rows


order by t.num_rows desc;

Hiç yorum yok: