USER_SOURCE 用户的存储过程、函数的源代码字典
DBA_SOURCE 整个系统所有用户的存储过程、函数的源代码字典
ALL_SOURCE 当前用户能使用的存储过程(包括其她用户授权)、函数的源代码字典
USER_ERRORS 用户的存储过程、函数的源代码存在错误的信息字典
SQL> select * from user_source where type='PROCEDURE';
NAME
------------------------------ ------------ ---------- --------------------------------------------------------------------------------
INSERTDEPT
INSERTDEPT
INSERTDEPT
INSERTDEPT
INSERTDEPT
INSERTDEPT
INSERTDEPT
INSERTDEPT
SQL> select * from user_objects where
OBJECT_NAME
-------------------------------------------------------------------------------- ------------------------------ ---------- -------------- ------------------- ----------- ------------- ------------------- ------- --------- --------- ---------
INSERTDEPT
INSERTEMP
SQL> desc user_source;
Name Type
---- -------------- -------- ------- -------------------------------------------------------------------------------------------------------------
NAME VARCHAR2(30)
TYPE VARCHAR2(12)
"PACKAGE", "PACKAGE BODY" or "JAVA SOURCE"
LINE NUMBER
TEXT VARCHAR2(4000) Y
==============end=============