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

网络编程 Oracle 视图 ALL_JAVA_CLASSES 官方解释，作用，如何使用详细说明 10-17

ALL_JAVA_CLASSES视图是Oracle数据库提供的一个视图，用于显示数据库中安装的所有Java类的内容。它由3列组成:OWNER,CLASS_NAME和SOURCE_TEXT。

OWNER字段涵盖视图中所列出的每个类的所有者。

CLASS_NAME字段包含正在显示的类的完整名称，该名称可以在Java应用程序中使用。

SOURCE_TEXT字段包含了表示Java类源代码的文本字符串，以及使用数据字典中的DBMS_JAVACLASS.LOADJAVACLASS函数加载到数据库中的任何类文件的JAR。

ALL_JAVA_CLASSES视图可以用于查找特定Java类的内容，以便使用，也可以用于展示系统中所有安装的类。要使用它，用户可以执行SQL查询，以检索一个，多个或所有的Java类的内容的完整列表：

SELECT CLASS_NAME, SOURCE_TEXT FROM ALL_JAVA_CLASSES WHERE OWNER=’owner’;

这个句子将显示拥有者所有的Java类的完整列表，其中包含类的名称和源代码。

ALL_JAVA_CLASSES displays class level information about the stored Java classes accessible to the current user.

Related Views

DBA_JAVA_CLASSES displays class level information about all stored Java classes in the database.
USER_JAVA_CLASSES displays class level 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
`MAJOR`	`NUMBER`		Major version number of the Java class, as defined in the JVM specification
`MINOR`	`NUMBER`		Minor version number of the Java class, as defined in the JVM specification
`KIND`	`VARCHAR2(50)`		Indicates whether the stored object is a Java class (`CLASS`) or a Java interface (`INTERFACE`)
`ACCESSIBILITY`	`VARCHAR2(9)`		Accessibility of the Java class
`IS_INNER`	`VARCHAR2(3)`		Indicates whether this Java class is an inner class (`YES`) or not (`NO`)
`IS_ABSTRACT`	`VARCHAR2(3)`		Indicates whether this Java class is an abstract class (`YES`) or not (`NO`)
`IS_FINAL`	`VARCHAR2(3)`		Indicates whether this Java class is a final class (`YES`) or not (`NO`)
`IS_STATIC`	`VARCHAR2(3)`		Indicates whether this is a static inner class (`YES`) or not (`NO`)
`IS_STRICTFP`	`VARCHAR2(3)`		Indicates whether the class is declared strict floating point for portability (`YES`) or not (`NO`)
`IS_SYNTHETIC`	`VARCHAR2(3)`		Indicates whether this is an inner class generated by the compiler (`YES`) or not (`NO`)
`IS_DEBUG`	`VARCHAR2(3)`		Indicates whether this Java class contains debug information (`YES`) or not (`NO`)
`SOURCE`	`VARCHAR2(4000)`		Source designation of the Java class
`SUPER`	`VARCHAR2(4000)`		Super class of this Java class
`OUTER`	`VARCHAR2(4000)`		Outer class of this Java class if this Java class is an inner class

568数据