Oracle 视图 USER_PROCEDURES 官方解释,作用,如何使用详细说明
本站中文解释
USER_PROCEDURES是Oracle中的一个视图,它提供了指定用户中所有存储过程的简要信息,包括存储过程名称,作者,定义,参数列表,执行计划类型等。
使用USER_PROCEDURES视图时,我们可以查看所有指定用户中的存储过程。例如,我们可以使用SQL语句如下展示这些存储过程的简要信息:
SELECT * FROM user_procedures;
此外,我们还可以查看指定存储过程的信息,如:
SELECT * FROM user_procedures WHERE proc_name = ‘my_procedure’;
官方英文解释
USER_PROCEDURES
lists all functions and procedures that are owned by the current user, along with their associated properties. Its columns (except OWNER
) are the same as those in ALL_PROCEDURES
.
See Also:
-
“ALL_PROCEDURES”
-
“USER_ARGUMENTS” for information about the arguments of the functions and procedures owned by the current user