查询存储过程，函数，序列，表，视图的名字

select object_name from user_objects where object_type = 'PROCEDURE'

select object_name from user_objects where object_type = 'FUNCTION'

select object_name from user_objects where object_type = 'SEQUENCE'

select object_name from user_objects where object_type = 'INDEX'

select object_name from user_objects where object_type = 'TABLE'

select object_name from user_objects where object_type = 'VIEW'

或：

select * from user_tables;

select view_name from user_views;

select view_name from user_views;

select sequence_name from user_sequences;