Note
This view was introduced in OceanBase Database V4.2.5. Data types defined in a package are displayed in this view only if the package is successfully compiled.
Purpose
The USER_PLSQL_TYPE_ATTRS view displays the overall information about the RECORD data types defined in packages of the current user.
Applicability
This view applies only to OceanBase Database in Oracle mode.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| TYPE_NAME | VARCHAR2(136) | NO | The name of the PL/SQL data type. |
| PACKAGE_NAME | VARCHAR2(128) | YES | The name of the package to which the PL/SQL data type belongs. |
| ATTR_NAME | VARCHAR2(128) | NO | The name of the attribute in the data type. |
| ATTR_TYPE_MOD | VARCHAR2(7) | NO | The modifier of the attribute type. |
| ATTR_TYPE_OWNER | VARCHAR2(128) | NO | The username 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 to which the attribute type belongs. |
| 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 character data types are used. |
Sample query
View the general information of a record type defined in the package of the current user.
obclient> SELECT * FROM SYS.USER_PLSQL_TYPE_ATTRS;
The query result is as follows:
+-----------+--------------+-----------+---------------+-----------------+----------------+-------------------+--------+-----------+-------+--------------------+---------+-----------+
| TYPE_NAME | PACKAGE_NAME | ATTR_NAME | ATTR_TYPE_MOD | ATTR_TYPE_OWNER | ATTR_TYPE_NAME | ATTR_TYPE_PACKAGE | LENGTH | PRECISION | SCALE | CHARACTER_SET_NAME | ATTR_NO | CHAR_USED |
+-----------+--------------+-----------+---------------+-----------------+----------------+-------------------+--------+-----------+-------+--------------------+---------+-----------+
| REC | MY_REC_TYPES | K | NULL | NULL | NUMBER | NULL | -1 | -1 | -85 | CHAR_CS | 3 | B |
| REC | MY_REC_TYPES | B | NULL | NULL | NUMBER | NULL | -1 | -1 | -85 | CHAR_CS | 2 | B |
| REC | MY_REC_TYPES | A | NULL | NULL | NUMBER | NULL | -1 | -1 | -85 | CHAR_CS | 1 | B |
+-----------+--------------+-----------+---------------+-----------------+----------------+-------------------+--------+-----------+-------+--------------------+---------+-----------+
3 rows in set
References
View the record type information defined in all packages accessible to the current user: ALL_PLSQL_TYPE_ATTRS.
View the record type information defined in all packages in the current tenant: DBA_PLSQL_TYPE_ATTRS