select OBJECT_TYPE,COUNT(*) from all_objects where OWNER='用户名'
GROUP BY OBJECT_TYPE;
用户名处大写
查看oracle某个用户下有多少种对象类型,以及每种类型中对象的个数
最新推荐文章于 2022-08-07 16:33:00 发布
select OBJECT_TYPE,COUNT(*) from all_objects where OWNER='用户名'
GROUP BY OBJECT_TYPE;
用户名处大写