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 the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

Owner of the type

TYPE_NAME

VARCHAR2(128)

NOT NULL

Name of the type

TYPE_OID

RAW(16)

NOT NULL

Object identifier (OID) of the type

EXTERNAL_NAME

VARCHAR2(4000)

External class name of the type

USING

VARCHAR2(21)

Representation of the type:

  • SQLData

  • CustomDatum

  • Serializable

  • Serializable Internal

  • ORAData

TYPECODE

VARCHAR2(128)

Typecode of the type

ATTRIBUTES

NUMBER

Number of attributes (if any) in the type

METHODS

NUMBER

Number of methods (if any) in the type

PREDEFINED

VARCHAR2(3)

Indicates whether the type is a predefined type (YES) or not (NO)

INCOMPLETE

VARCHAR2(3)

Indicates whether the type is an incomplete type (YES) or not (NO)

FINAL

VARCHAR2(3)

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

INSTANTIABLE

VARCHAR2(3)

Indicates whether the type is an instantiable type (YES) or not (NO)

SUPERTYPE_OWNER

VARCHAR2(128)

Owner of the supertype (NULL if type is not a subtype)

SUPERTYPE_NAME

VARCHAR2(128)

Name of the supertype (NULL if type is not a subtype)

LOCAL_ATTRIBUTES

NUMBER

Number of local (not inherited) attributes (if any) in the subtype

LOCAL_METHODS

NUMBER

Number of local (not inherited) methods (if any) in the subtype

See Also:

  • “DBA_SQLJ_TYPES”

  • “USER_SQLJ_TYPES”


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