本文提供了一系列SQL查询示例，用于统计Oracle数据库中不同类型的对象数量，包括过程、索引、视图和序列等。
select count(1) from user_objects where object_type = 'PROCEDURE'
select count(1) from user_objects where object_type = 'INDEX'
select count(1) from user_objects where object_type = 'VIEW'
select count(1) from user_objects where object_type = 'INDEX'
select count(1) from user_objects where object_type = 'VIEW'
select count(1) from user_objects where object_type = 'SEQUENCE'
... ...
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
