本站中文解释
视图
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
