user_source数据字典和oracle中对象的源代码

 在oracle中，对象的源代码是可以从user_source数据字典中

Name Type           Nullable Default Comments                                                                                                     
---- -------------- -------- ------- -------------------------------------------------------------------------------------------------------------
NAME VARCHAR2(30)   Y                Name of the object                                                                                           
TYPE VARCHAR2(12)   Y                Type of the object: "TYPE", "TYPE BODY", "PROCEDURE", "FUNCTION",
                                                                                               "PACKAGE", "PACKAGE BODY" or "JAVA SOURCE"
LINE NUMBER         Y                Line number of this line of source                                                                           
TEXT VARCHAR2(4000) Y                Source text                                                                                                  

这里是按照行来存储的，比如统计行数就可以通过这个数据字典来统计，也可以根据这个数据字典来进行对PL/SQL源代码的处理，比如生成PL/SQL DOC或通过工具进行代码检查。