Purpose
The ALL_TYPE_ATTRS view displays the attributes of available user-defined types in the database.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_TYPE_ATTRS
USER_TYPE_ATTRS
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the object. |
| TYPE_NAME | VARCHAR2(64) | NO | The name of the type. |
| ATTR_NAME | VARCHAR2(64) | NO | The name of the type attribute. |
| ATTR_TYPE_MOD | VARCHAR2(7) | NO | The type modifier of the attribute. At present, this column is not used. |
| ATTR_TYPE_OWNER | VARCHAR2(128) | NO | The owner of the type of the attribute. |
| ATTR_TYPE_NAME | VARCHAR2(324) | NO | The name of the type of the attribute. |
| LENGTH | NUMBER(38) | NO | The length of the type of the attribute. |
| NUMBER_PRECISION | NUMBER(38) | NO | The decimal precision of the number attribute. |
| SCALE | NUMBER(38) | NO | The number of digits on the right of the decimal point in a number. |
| CHARACTER_SET_NAME | CHAR(7) | NO | The character set for the type of the attribute. |
| ATTR_NO | NUMBER(38) | NO | The serial number of the attribute. |
| INHERITED | CHAR(2) | NO | Indicates whether the attribute is inherited from a supertype. |
| CHAR_USED | CHAR(1) | YES | At present, this column is not supported and is NULL by default. |