Oracle 视图 ALL_SQLJ_TYPES 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图ALL_SQLJ_TYPES用于查询用户账户中已经创建的所有SQLJ类型,即类型名称、Schema,数据类型和其他一些别的属性。
使用ALL_SQLJ_TYPES视图的语法形式如下:
SELECT * FROM ALL_SQLJ_TYPES;
官方英文解释
ALL_SQLJ_TYPES
describes the SQLJ object types accessible to the current user.
Related Views
-
DBA_SQLJ_TYPES
describes all SQLJ object types in the database. -
USER_SQLJ_TYPES
describes the SQLJ object types owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
Owner of the type |
|
|
|
|
Name of the type |
|
|
|
Object identifier (OID) of the type |
|
|
External class name of the type |
|
|
|
Representation of the type:
|
|
|
|
Typecode of the type |
|
|
|
Number of attributes (if any) in the type |
|
|
|
Number of methods (if any) in the type |
|
|
|
Indicates whether the type is a predefined type ( |
|
|
|
Indicates whether the type is an incomplete type ( |
|
|
|
Indicates whether the type is a final type ( |
|
|
|
Indicates whether the type is an instantiable type ( |
|
|
|
Owner of the supertype (NULL if type is not a subtype) |
|
|
|
Name of the supertype (NULL if type is not a subtype) |
|
|
|
Number of local (not inherited) attributes (if any) in the subtype |
|
|
|
Number of local (not inherited) methods (if any) in the subtype |
See Also:
-
“DBA_SQLJ_TYPES”
-
“USER_SQLJ_TYPES”