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 is a view that displays information about record types defined in the current user's package. This view displays only if the package is compiled.
Functionality Applicability
This view applies only to the Oracle mode of OceanBase Database.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TYPE_NAME | VARCHAR2(136) | NO | Type |
| PACKAGE_NAME | VARCHAR2(128) | YES | The name of a package that contains PL/SQL types. |
| 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 attribute value length. |
| PRECISION | NUMBER(38) | NO | The precision of the attribute value. |
| SCALE | NUMBER(38) | NO | Ratio of attribute values. |
| CHARACTER_SET_NAME | VARCHAR2(44) | NO | The name of the character set. |
| ATTR_NO | NUMBER(38) | NO | The attribute number. |
| CHAR_USED | VARCHAR2(1) | NO | Indicates whether character data type is used. |
Sample query
obclient> SELECT * FROM USER_PLSQL_TYPE_ATTRS;
References
- Query ALL_PLSQL_TYPE_ATTRS to obtain overall information about the record type that is defined in a package.
- To query information about the record type defined in the package, refer to DBA_PLSQL_TYPE_ATTRS.
