oracle查询表的存储过程,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表，视图，存储过程，函数，序列.....查询

标签：where   oracle   procedure   bsp   函数   序列   存储过程   object   table

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：http://www.cnblogs.com/26JRS/p/6719424.html