Oracle 视图 ALL_SQLJ_TYPES 官方解释,作用,如何使用详细说明
  iDU31ygkXmx7 2023年11月21日 17 0

本站中文解释

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”

【版权声明】本文内容来自摩杜云社区用户原创、第三方投稿、转载,内容版权归原作者所有。本网站的目的在于传递更多信息,不拥有版权,亦不承担相应法律责任。如果您发现本社区中有涉嫌抄袭的内容,欢迎发送邮件进行举报,并提供相关证据,一经查实,本社区将立刻删除涉嫌侵权内容,举报邮箱: cloudbbs@moduyun.com

  1. 分享:
最后一次编辑于 2023年11月21日 0

暂无评论

iDU31ygkXmx7