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