• <legend id='2N0HQ'><style id='2N0HQ'><dir id='2N0HQ'><q id='2N0HQ'></q></dir></style></legend>
    <tfoot id='2N0HQ'></tfoot>
      <i id='2N0HQ'><tr id='2N0HQ'><dt id='2N0HQ'><q id='2N0HQ'><span id='2N0HQ'><b id='2N0HQ'><form id='2N0HQ'><ins id='2N0HQ'></ins><ul id='2N0HQ'></ul><sub id='2N0HQ'></sub></form><legend id='2N0HQ'></legend><bdo id='2N0HQ'><pre id='2N0HQ'><center id='2N0HQ'></center></pre></bdo></b><th id='2N0HQ'></th></span></q></dt></tr></i><div id='2N0HQ'><tfoot id='2N0HQ'></tfoot><dl id='2N0HQ'><fieldset id='2N0HQ'></fieldset></dl></div>
      • <bdo id='2N0HQ'></bdo><ul id='2N0HQ'></ul>

        <small id='2N0HQ'></small><noframes id='2N0HQ'>

        获取 Oracle 数据库中所有函数和过程的列表

        时间:2023-11-03
        • <i id='CINRM'><tr id='CINRM'><dt id='CINRM'><q id='CINRM'><span id='CINRM'><b id='CINRM'><form id='CINRM'><ins id='CINRM'></ins><ul id='CINRM'></ul><sub id='CINRM'></sub></form><legend id='CINRM'></legend><bdo id='CINRM'><pre id='CINRM'><center id='CINRM'></center></pre></bdo></b><th id='CINRM'></th></span></q></dt></tr></i><div id='CINRM'><tfoot id='CINRM'></tfoot><dl id='CINRM'><fieldset id='CINRM'></fieldset></dl></div>
        • <legend id='CINRM'><style id='CINRM'><dir id='CINRM'><q id='CINRM'></q></dir></style></legend>
            • <bdo id='CINRM'></bdo><ul id='CINRM'></ul>
              <tfoot id='CINRM'></tfoot>
            • <small id='CINRM'></small><noframes id='CINRM'>

                <tbody id='CINRM'></tbody>

                1. 本文介绍了获取 Oracle 数据库中所有函数和过程的列表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  我正在比较三个 Oracle 模式.

                  I'm comparing three Oracle schemas.

                  我想获得每个数据库中使用的所有函数和过程的列表.这可以通过查询实现吗?(最好包括一个关于它们是否编译的标志)

                  I want to get a list of all the functions and procedures used in each database. Is this possible via a query? (preferably including a flag as to whether they compile or not)

                  理想情况下,最好有一个带有标志的查询,该标志说明函数/过程是否在每个模式中.但即使只是第一位也比手动检查每个架构要好.

                  Ideally it would be great to have a single query with a flag that states whether the function/procedure is in each schema. But even just the first bit would be better than manually inspecting each schema.

                  推荐答案

                  SELECT * FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('FUNCTION','PROCEDURE','PACKAGE')
                  

                  STATUS 列告诉您对象是 VALID 还是 INVALID.如果无效,则必须重新编译,ORACLE 之前无法告诉您是否有效.

                  The column STATUS tells you whether the object is VALID or INVALID. If it is invalid, you have to try a recompile, ORACLE can't tell you if it will work before.

                  这篇关于获取 Oracle 数据库中所有函数和过程的列表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  上一篇:为什么我不能在 SYS 拥有的对象上创建触发器? 下一篇:如何使用低权限的 PL-SQL 在 Oracle 中获取列数据类型?

                  相关文章

                2. <legend id='RXGMD'><style id='RXGMD'><dir id='RXGMD'><q id='RXGMD'></q></dir></style></legend>

                3. <i id='RXGMD'><tr id='RXGMD'><dt id='RXGMD'><q id='RXGMD'><span id='RXGMD'><b id='RXGMD'><form id='RXGMD'><ins id='RXGMD'></ins><ul id='RXGMD'></ul><sub id='RXGMD'></sub></form><legend id='RXGMD'></legend><bdo id='RXGMD'><pre id='RXGMD'><center id='RXGMD'></center></pre></bdo></b><th id='RXGMD'></th></span></q></dt></tr></i><div id='RXGMD'><tfoot id='RXGMD'></tfoot><dl id='RXGMD'><fieldset id='RXGMD'></fieldset></dl></div>

                      <tfoot id='RXGMD'></tfoot>

                        <bdo id='RXGMD'></bdo><ul id='RXGMD'></ul>

                      <small id='RXGMD'></small><noframes id='RXGMD'>