oracle依据用户查询空表

分类: IT文章 • 2024-12-24 09:14:49

oracle根据用户查询空表

select table_name,nvl(num_rows,1) from dba_tables t where t.owner='KSCENTER' order by nvl(num_rows,1) desc;