Note
This view is available starting with V4.3.5 for V4.3.x.
This view is available starting with V4.2.5 for V4.2.x.
Purpose
USER_PLSQL_TYPE_ATTRS displays the overall information of record types defined in the current user's package. The types in the package can be displayed in this view only when the package is successfully compiled.
Applicability
This view is applicable only to OceanBase Database in Oracle mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| TYPE_NAME | VARCHAR2(136) | NO | The name of the PL/SQL type. |
| PACKAGE_NAME | VARCHAR2(128) | YES | The name of the package that contains the PL/SQL type. |
| ATTR_NAME | VARCHAR2(128) | NO | The name of the attribute of the type. |
| ATTR_TYPE_MOD | VARCHAR2(7) | NO | The type modifier of the attribute. |
| ATTR_TYPE_OWNER | VARCHAR2(128) | NO | The name of the owner of the attribute type. |
| ATTR_TYPE_NAME | VARCHAR2(136) | NO | The name of the attribute type. |
| ATTR_TYPE_PACKAGE | VARCHAR2(128) | NO | The name of the package that contains the attribute type. |
| LENGTH | NUMBER(38) | NO | The length of the attribute value. |
| PRECISION | NUMBER(38) | NO | The precision of the attribute value. |
| SCALE | NUMBER(38) | NO | The scale of the attribute value. |
| CHARACTER_SET_NAME | VARCHAR2(44) | NO | The name of the character set. |
| ATTR_NO | NUMBER(38) | NO | The sequence number of the attribute. |
| CHAR_USED | VARCHAR2(1) | NO | Indicates whether a character data type is used. |
Sample query
obclient> SELECT * FROM USER_PLSQL_TYPE_ATTRS;
References
- Query the overall information of record types defined in a package: ALL_PLSQL_TYPE_ATTRS.
- Query the overall information of record types defined in a package: DBA_PLSQL_TYPE_ATTRS.