SELECT owner,object_name AS package_name,procedure_name AS method_name FROM dba_procedures WHERE object_type = 'PACKAGE'
如果您还需要私有方法,则无法在数据字典中直接访问该信息.在这种情况下,您需要解析源代码(这显然会非常痛苦,特别是如果您碰巧在包中的公共或私有方法中嵌套了私有方法).
