Oracle教程 2023-04-04

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

本站中文解释

ALL_SQLJ_TYPE_METHODS视图是SQLJ视图，SQLJ(Structured Query Language Java)是一种用于集成Java类和过程的存储过程语言，它可以将服务器上的现有存储过程调用Java应用程序。
ALL_SQLJ_TYPE_METHODS视图显示数据库中的所有SQLJ类型定义的当前用户拥有的所有方法。

使用方法：
1、使用SELECT语句来查询ALL_SQLJ_TYPE_METHODS视图：
SELECT * FROM ALL_SQLJ_TYPE_METHODS;

2、使用WHERE子句来查询ALL_SQLJ_TYPE_METHODS视图，以限定所显示的记录：
SELECT *
FROM ALL_SQLJ_TYPE_METHODS
WHERE owner = ”;

官方英文解释

ALL_SQLJ_TYPE_METHODS describes the methods of the SQLJ object types accessible to the current user.

Related Views

DBA_SQLJ_TYPE_METHODS describes the methods of all SQLJ object types in the database.
USER_SQLJ_TYPE_METHODS describes the methods of the SQLJ 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
`EXTERNAL_VAR_NAME`	`VARCHAR2(4000)`		Name of the external variable
`METHOD_NO`	`NUMBER`	`NOT NULL`	Method number that distinguishes overloaded methods (not to be used as an ID number)
`METHOD_TYPE`	`VARCHAR2(6)`		Type of the method: `MAP` `ORDER` `PUBLIC`
`PARAMETERS`	`NUMBER`	`NOT NULL`	Number of parameters to the method
`RESULTS`	`NUMBER`	`NOT NULL`	Number of results returned by the method
`FINAL`	`VARCHAR2(3)`		Indicates whether the method is final (`YES`) or not (`NO`)
`INSTANTIABLE`	`VARCHAR2(3)`		Indicates whether the method is instantiable (`YES`) or not (`NO`)
`OVERRIDING`	`VARCHAR2(3)`		Indicates whether the method is overriding a supertype method (`YES`) or not (`NO`)
`INHERITED`	`VARCHAR2(3)`		Indicates whether the method is inherited from a supertype (`YES`) or not (`NO`)

本站中文解释

官方英文解释

相关推荐