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;

轉載于:https://www.cnblogs.com/26JRS/p/6719424.html