oracle查询数据库中存储过程、索引、视图等的数量

来源:互联网 发布:奥斯卡软件证书 编辑:程序博客网 时间:2024/06/18 13:17
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 = 'SEQUENCE'

... ...

0 0