Purpose
The USER_TYPES view displays user-defined types of the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_TYPES
ALL_TYPES
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| TYPE_NAME | VARCHAR2(64) | NO | The name of the type. |
| TYPE_OID | NUMBER(38) | NO | The object identifier (OID) of the type. |
| TYPECODE | VARCHAR2(10) | NO | The object type, such as OBJECT and COLL. |
| ATTRIBUTES | NUMBER(38) | NO | The number of attributes in the type. |
| METHODS | NUMBER(38) | NO | The number of methods in the type. |
| PREDEFINED | CHAR(2) | NO | Indicates whether the type is a predefined type. |
| INCOMPLETE | CHAR(2) | NO | Indicates whether the type is incomplete, which means the object has only a name and has no methods or attributes. |
| FINAL | CHAR(3) | NO | Indicates whether the type is a non-inheritable type. |
| INSTANTIABLE | CHAR(3) | NO | Indicates whether the type is instantiable. |
| SUPERTYPE_OWNER | VARCHAR2(30) | NO | The owner of the supertype. |
| SUPERTYPE_NAME | VARCHAR2(30) | NO | The name of the supertype. |
| LOCAL_ATTRIBUTES | NUMBER(38) | NO | The number of local attributes. |
| LOCAL_METHODS | NUMBER(38) | NO | The number of local methods. |
| TYPEID | NUMBER(38) | YES | At present, this column is not supported and is NULL by default. |