oracle表，视图，存储过程，函数，序列.....查询

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

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;

oracle表，视图，存储过程，函数，序列.....查询

原文：http://www.cnblogs.com/26JRS/p/6719424.html