Oracle教程 2023-02-23

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

本站中文解释

All_method_params表用于描述对象MESHTYPE中定义的所有属性，它为每个属性提供了一个描述性名称，并将其映射到数据类型和长度。

Oracle视图ALL_METHOD_PARAMS用于查看object_type为MESHTYPE的所有属性，它的字段包括OBJECT_NAME (对象名称)、OWNER (拥有者)、METHOD_NAME (方法名称)、METHOD_NO (方法编号)、PARAMETER_ID (参数编号)、PARAMETER_NAME (参数名称)、DATA_TYPE (数据类型)、TYPE_OWNER (类型拥有者)和TYPE_NAME (类型名称)。

使用方法：
SELECT *
FROM all_method_params
WHERE object_name = ‘ObjectName’
AND owner = ‘OwnerName’
AND method_name = ‘MethodName’
ORDER BY parameter_id;

官方英文解释

ALL_METHOD_PARAMS describes the method parameters of the object types accessible to the current user.

Related Views

DBA_METHOD_PARAMS describes the method parameters of all object types in the database.
USER_METHOD_PARAMS describes the method parameters of the object types owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the type
`TYPE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the type
`METHOD_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the method
`METHOD_NO`	`NUMBER`	`NOT NULL`	For an overloaded method, a number distinguishing this method from others of the same. Do not confuse this number with the object ID.
`PARAM_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the parameter
`PARAM_NO`	`NUMBER`	`NOT NULL`	Parameter number (position)
`PARAM_MODE`	`VARCHAR2(6)`		Mode of the parameter (`IN`, `OUT`, `IN OUT`)
`PARAM_TYPE_MOD`	`VARCHAR2(7)`		Whether this parameter is a `REF` to another object
`PARAM_TYPE_OWNER`	`VARCHAR2(128)`		Owner of the type of the parameter
`PARAM_TYPE_NAME`	`VARCHAR2(128)`		Name of the type of the parameter
`CHARACTER_SET_NAME`	`VARCHAR2(44)`		Whether the character set or the method is fixed-length character set (`CHAR_CS`) or fixed-length national character set (`NCHAR_CS`), or a particular character set specified by the user

本站中文解释

官方英文解释

相关推荐