oracle 查看用户表，存储过程，触发器，函数对象

oracle 查看用户表，存储过程，触发器，函数对象

SQL> desc user_objects;
名称 是否为空? 类型
----------------------------------------- -------- ---------------

OBJECT_NAME VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(19)
CREATED DATE
LAST_DDL_TIME DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
NAMESPACE NUMBER
EDITION_NAME VARCHAR2(30)

查看触发器 trigger：

SQL> select object_name from user_objects where object_type='TRIGGER';

查看索引 index：

SQL> select object_name from user_objects where object_type='INDEX';

查看表 table：

SQL> select object_name from user_objects where object_type='TABLE';