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


数据运维技术 » Oracle 视图 USER_ARGUMENTS 官方解释,作用,如何使用详细说明