blocks|key|479333|text|这可能对某些人有用，这也是一种找出包体上指定的过程和函数的方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|479334|select+name,+
+++++++type,
+++++++decode(usage,'DECLARATION',+'body+only',+'DEFINITION',+'spec+and+body',+usage)+defined_on,
+++++++line+body_line
++from+user_identifiers+ui
++where+type+in+('PROCEDURE',+'FUNCTION')
++and+usage_context_id+=+(select+usage_id
++++from+user_identifiers
++++++where+object_name+=+ui.object_name
++++++++and+object_type+=+ui.object_type
++++++++and+usage_context_id+=+0)
++and+object_name+=+'your+package+name'
++and+object_type+=+'PACKAGE+BODY'
++order+by+name|code-block|syntax|javascript|479335|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Maybe useful to someone, this is a way to find out procedure and function specified on package body only too.

<pre><code>select name, 
 type,
 decode(usage,'DECLARATION', 'body only', 'DEFINITION', 'spec and body', usage) defined_on,
 line body_line
 from user_identifiers ui
 where type in ('PROCEDURE', 'FUNCTION')
 and usage_context_id = (select usage_id
 from user_identifiers
 where object_name = ui.object_name
 and object_type = ui.object_type
 and usage_context_id = 0)
 and object_name = 'your package name'
 and object_type = 'PACKAGE BODY'
 order by name
</code></pre>

blocks|key|479382|text|我使用这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|479383|您的包：|479384|SELECT+*
FROM+ALL_OBJECTS
WHERE+OBJECT_TYPE+=+'PACKAGE'+
++++and+owner+=+'owner_name'
++++and+object_name+=+'package_name'|code-block|syntax|javascript|479385|您的过程(仅来自规范，即全局)：|479386|select+*
+from+all_procedures
+where+owner+=+'owner_name'
+and+object_name+=+'package_name'|479387|和来自过程的in/out参数：|479388|select+*+
from+ALL_ARGUMENTS+
where+owner+=+'owner_name'
++++and+package_name+=+'package_name'
++++and+object_name+=+'procedure_name'|479389|享受吧！|479390|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|10|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|11|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

I use this one:

your package:

<pre><code>SELECT *
FROM ALL_OBJECTS
WHERE OBJECT_TYPE = 'PACKAGE' 
 and owner = 'owner_name'
 and object_name = 'package_name'
</code></pre>

your procedures (only from specs, i.e. global):

<pre><code>select *
 from all_procedures
 where owner = 'owner_name'
 and object_name = 'package_name'
</code></pre>

and in/out arguments from procedure: 

<pre><code>select * 
from ALL_ARGUMENTS 
where owner = 'owner_name'
 and package_name = 'package_name'
 and object_name = 'procedure_name'
</code></pre>

enjoy!

Can I get the name of all the function inside a package.
Suppose I have a package PKG_OWA and I want to list all the procedure inside the package.

How to get list of all the procedure inside a package oracle

我能得到一个包中所有函数的名称吗？假设我有一个包PKG_OWA，并且我想列出包中的所有过程。

问如何获取oracle包中所有过程的列表
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何获取oracle包中所有过程的列表EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何获取oracle包中所有过程的列表
EN