Oracle 视图 USER_ARGUMENTS 官方解释，作用，如何使用详细说明

本站中文解释

视图

USER_ARGUMENTS视图是Oracle中架构用户的一个内部视图，用于提供存储过程参数的相关信息的检索，即存储过程参数的类型，缺省值，位置和方向。

使用方法：

1.查询某个特定的存储过程所有参数信息

SELECT * FROM USER_ARGUMENTS WHERE OBJECT_NAME = ‘procedure_name’;

2.查询某个特定的存储过程参数的类型

SELECT DATA_TYPE FROM USER_ARGUMENTS WHERE OBJECT_NAME = ‘procedure_name’ AND ARGUMENT_NAME = ‘parameter_name’;

官方英文解释

USER_ARGUMENTS lists the arguments of the functions and procedures that are owned by the current user. Its columns (except for OWNER) are the same as those in ALL_ARGUMENTS.

See Also:

• “ALL_ARGUMENTS”

• “USER_PROCEDURES” for information about the functions and procedures that are owned by the current user