Oracle教程 2023-04-02

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

和USER_SQLJ_TYPE_ATTRS

Oracle 视图是特殊的数据表，存储在数据库中。 ALL_SQLJ_TYPE_ATTRS 和 USER_SQLJ_TYPE_ATTRS 视图显示所有SQLJ类型的定义属性信息。

ALL_SQLJ_TYPE_ATTRS 视图显示以下几种所有定义 SQLJ 类型的属性信息：类型名称，继承。该视图中的每一行都与一个类型的属性关联：

USER_SQLJ_TYPE_ATTRS 视图只显示当前用户所定义的SQLJ类型的属性信息。该视图中的每一行都与一个类型的属性关联：

要使用这两个视图，可以像使用其他任何视图一样进行访问，这可以通过下面的SQL语句：

SELECT * FROM all_sqlj_type_attrs;
SELECT * FROM user_sqlj_type_attrs;

ALL_SQLJ_TYPE_ATTRS describes the attributes of the SQLJ object types accessible to the current user.

Related Views

DBA_SQLJ_TYPE_ATTRS describes the attributes of all SQLJ object types in the database.
USER_SQLJ_TYPE_ATTRS describes the attributes of the 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
`ATTR_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the attribute
`EXTERNAL_ATTR_NAME`	`VARCHAR2(4000)`		External name of the attribute
`ATTR_TYPE_MOD`	`VARCHAR2(7)`		Type modifier of the attribute: `REF` `POINTER`
`ATTR_TYPE_OWNER`	`VARCHAR2(128)`		Owner of the type of the attribute
`ATTR_TYPE_NAME`	`VARCHAR2(128)`		Name of the type of the attribute
`LENGTH`	`NUMBER`		Length of the `CHAR` attribute, or maximum length of the `VARCHAR` or `VARCHAR2` attribute.
`PRECISION`	`NUMBER`		Decimal precision of the `NUMBER` or `DECIMAL` attribute, or binary precision of the `FLOAT` attribute.
`SCALE`	`NUMBER`		Scale of the `NUMBER` or `DECIMAL` attribute
`CHARACTER_SET _NAME`	`VARCHAR2(44)`		Character set name of the attribute (`CHAR_CS` or `NCHAR_CS`)
`ATTR_NO`	`NUMBER`	`NOT NULL`	Syntactical order number or position of the attribute as specified in the type specification or `CREATE TYPE` statement (not to be used as an ID number)
`INHERITED`	`VARCHAR2(3)`		Indicates whether the attribute is inherited from a supertype (`YES`) or not (`NO`)