select table_name,nvl(num_rows,1) from dba_tables t where t.owner='KSCENTER' order by nvl(num_rows,1) desc;
oracle根据用户查询空表
最新推荐文章于 2023-03-01 10:35:46 发布
select table_name,nvl(num_rows,1) from dba_tables t where t.owner='KSCENTER' order by nvl(num_rows,1) desc;