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_PARAMSdescribes the method parameters of all object types in the database.USER_METHOD_PARAMSdescribes the method parameters of the object types owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
| Owner of the type |
|
|
| Name of the type |
|
|
| Name of the method |
|
|
| For an overloaded method, a number distinguishing this method from others of the same. Do not confuse this number with the object ID. |
|
|
| Name of the parameter |
|
|
| Parameter number (position) |
|
| Mode of the parameter ( | |
|
| Whether this parameter is a | |
|
| Owner of the type of the parameter | |
|
| Name of the type of the parameter | |
|
| Whether the character set or the method is fixed-length character set ( |
See Also:
“DBA_METHOD_PARAMS”
“USER_METHOD_PARAMS”
编辑：广州鸿名健康科技有限公司
标签：名称,属性,数据类型,对象,编号