获取Oracle数据库中所有功能和过程的列表 [英] Get a list of all functions and procedures in an Oracle database

问题描述

我正在比较三种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列告诉您对象是有效还是无效.如果无效，则必须尝试重新编译，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数据库中所有功能和过程的列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！