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

本站中文解释

Oracle视图ALL_JAVA_METHODS用于查询该用户下所有的Java方法签名和函数的说明,提供的信息包括所有的输入参数和返回类型,以及每个方法的状态:是否可用/运行时可见/实现可见。

使用方法:

1.在SQL中执行:
SELECT * FROM ALL_JAVA_METHODS;

2.从PL / SQL中调用:
BEGIN
SELECT * FROM ALL_JAVA_METHODS;
END;

官方英文解释

ALL_JAVA_METHODS displays method information about the stored Java classes accessible to the current user.

Related Views

  • DBA_JAVA_METHODS displays method information about all stored Java classes in the database.

  • USER_JAVA_METHODS displays method information about the stored Java classes 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 Java class

NAME

VARCHAR2(4000)

Name of the Java class

METHOD_INDEX

NUMBER

Index of the method

METHOD_NAME

VARCHAR2(4000)

Name of the method identified by the METHOD_INDEX column

ACCESSIBILITY

VARCHAR2(9)

Accessibility of the method:

  • PUBLIC

  • PRIVATE

  • PROTECTED

IS_STATIC

VARCHAR2(3)

Indicates whether the method is a static method (YES) or not (NO)

IS_FINAL

VARCHAR2(3)

Indicates whether the method is a final method (YES) or not (NO)

IS_SYNCHRONIZED

VARCHAR2(3)

Indicates whether the method is a synchronized method (YES) or not (NO)

HAS_VARARGS

VARCHAR2(3)

Indicates whether the method has a variable number of arguments (YES) or not (NO)

IS_NATIVE

VARCHAR2(3)

Indicates whether the method is a native method (YES) or not (NO)

IS_ABSTRACT

VARCHAR2(3)

Indicates whether the method is an abstract method (YES) or not (NO)

IS_STRICTFP

VARCHAR2(3)

Indicates whether the method is a strict method (YES) or not (NO)

IS_SYNTHETIC

VARCHAR2(3)

Indicates whether the method is generated by the compiler (YES) or not (NO)

ARGUMENTS

NUMBER

Number of arguments of the method

THROWS

NUMBER

Number of exceptions thrown by the method

ARRAY_DEPTH

NUMBER

Array depth of the return type of the method

BASE_TYPE

VARCHAR2(7)

Base type of the return type of the method:

  • int

  • long

  • float

  • double

  • boolean

  • byte

  • char

  • short

  • class

  • void

RETURN_CLASS

VARCHAR2(4000)

Actual class name of the return value if the base type is class

IS_COMPILED

VARCHAR2(3)

Indicates whether the Java method has been natively compiled by the JIT compiler (YES) or not (NO)

See Also:

  • “DBA_JAVA_METHODS”

  • “USER_JAVA_METHODS”


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