[Oracle] 查询当前用户下所有表、视图、序列、函数、存储过程、包

--tables
select 'tables-'|| count（*）from user_tables;

--views
select 'views-'||count（*） from user_views;

--seqs
select  'seqs-'||count(*) from user_sequences;

--functions
select 'functions-'||count(*) from user_objects where object_type='FUNCTION';

--procedure
select 'procedure-'||count(*) from user_objects where object_type='PROCEDURE';

--package
select 'package-'||count(*) from user_objects where object_type='PACKAGE';