Note
This view is available starting with V4.3.5 for V4.3.x.
For V4.2.x, this view is available starting with V4.2.5.
Purpose
DBA_PLSQL_TYPE_ATTRS displays overall information about record types defined in packages. The types in the package can be displayed in this view only after the package is successfully compiled.
Applicability
This view is available only in Oracle-compatible mode.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | YES | The name of the owner of the PL/SQL type attribute. |
| TYPE_NAME | VARCHAR2(136) | NO | The name of the PL/SQL type. |
| PACKAGE_NAME | VARCHAR2(128) | YES | The name of the package containing the PL/SQL type. |
| ATTR_NAME | VARCHAR2(128) | NO | The name of the type attribute. |
| 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's type. |
| ATTR_TYPE_NAME | VARCHAR2(136) | NO | The name of the attribute's type. |
| ATTR_TYPE_PACKAGE | VARCHAR2(128) | NO | The name of the package containing the attribute's 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 the character data type is used. |
Sample query
obclient> SELECT * FROM DBA_PLSQL_TYPE_ATTRS;
The return result is as follows:
+-------+-----------------------------+--------------+---------------------+---------------+-----------------+-----------------------------------+-------------------+-----------+-----------+-------+--------------------+---------+-----------+
| OWNER | 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 |
+-------+-----------------------------+--------------+---------------------+---------------+-----------------+-----------------------------------+-------------------+-----------+-----------+-------+--------------------+---------+-----------+
| SYS | SYS$BULK_ERROR_RECORD | STANDARD | ERROR_CODE | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 2 | B |
| SYS | SYS$BULK_ERROR_RECORD | STANDARD | ERROR_INDEX | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 1 | B |
| SYS | <TUPLE_1> | STANDARD | DUMMY | NULL | NULL | CHAR | NULL | 1 | 2 | -1 | CHAR_CS | 1 | B |
| SYS | <RECORD_1> | STANDARD | DUMMY | NULL | NULL | CHAR | NULL | 1 | 2 | -1 | CHAR_CS | 1 | B |
| SYS | <ADT_1> | STANDARD | DUMMY | NULL | NULL | CHAR | NULL | 1 | 2 | -1 | CHAR_CS | 1 | B |
| SYS | TIMESTAMP_LTZ_UNCONSTRAINED | STANDARD | NULL | NULL | NULL | TIMESTAMP(9) WITH LOCAL TIME ZONE | NULL | -1 | 28 | 9 | CHAR_CS | 0 | B |
| SYS | DSINTERVAL_UNCONSTRAINED | STANDARD | NULL | NULL | NULL | INTERVAL DAY(9) TO SECOND(9) | NULL | -1 | -1 | 99 | CHAR_CS | 0 | B |
| SYS | YMINTERVAL_UNCONSTRAINED | STANDARD | NULL | NULL | NULL | INTERVAL YEAR(9) TO MONTH | NULL | -1 | -1 | 9 | CHAR_CS | 0 | B |
| SYS | TIMESTAMP_TZ_UNCONSTRAINED | STANDARD | NULL | NULL | NULL | TIMESTAMP(9) WITH TIME ZONE | NULL | -1 | 28 | 9 | CHAR_CS | 0 | B |
| SYS | TIMESTAMP_UNCONSTRAINED | STANDARD | NULL | NULL | NULL | TIMESTAMP(9) | NULL | -1 | 28 | 9 | CHAR_CS | 0 | B |
| SYS | CHAR LARGE OBJECT | STANDARD | NULL | NULL | NULL | CLOB | NULL | 536870911 | -1 | 0 | CHAR_CS | 0 | B |
| SYS | BINARY LARGE OBJECT | STANDARD | NULL | NULL | NULL | BLOB | NULL | 536870911 | -1 | 0 | CHAR_CS | 0 | B |
| SYS | CHARACTER LARGE OBJECT | STANDARD | NULL | NULL | NULL | CLOB | NULL | 536870911 | -1 | 0 | CHAR_CS | 0 | B |
| SYS | CHAR VARYING | STANDARD | NULL | NULL | NULL | VARCHAR2 | NULL | 32767 | 2 | -1 | CHAR_CS | 0 | B |
| SYS | CHARACTER VARYING | STANDARD | NULL | NULL | NULL | VARCHAR2 | NULL | 32767 | 2 | -1 | CHAR_CS | 0 | B |
| SYS | LONG | STANDARD | NULL | NULL | NULL | VARCHAR2 | NULL | 32760 | 2 | -1 | CHAR_CS | 0 | B |
| SYS | STRING | STANDARD | NULL | NULL | NULL | VARCHAR2 | NULL | 32760 | 2 | -1 | CHAR_CS | 0 | B |
| SYS | DEC | STANDARD | NULL | NULL | NULL | NUMBER | NULL | -1 | 38 | 0 | CHAR_CS | 0 | B |
| SYS | DOUBLE PRECISION | STANDARD | NULL | NULL | NULL | FLOAT | NULL | -1 | 126 | -85 | CHAR_CS | 0 | B |
| SYS | DESC_REC3 | DBMS_SQL | COL_TYPE_NAME_LEN | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 13 | B |
| SYS | DESC_REC3 | DBMS_SQL | COL_TYPE_NAME | NULL | NULL | VARCHAR2 | NULL | 32 | 2 | -1 | CHAR_CS | 12 | B |
| SYS | DESC_REC3 | DBMS_SQL | COL_NULL_OK | NULL | NULL | NUMBER | NULL | -1 | 1 | 0 | CHAR_CS | 11 | C |
| SYS | DESC_REC3 | DBMS_SQL | COL_CHARSETFORM | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 10 | B |
| SYS | DESC_REC3 | DBMS_SQL | COL_CHARSETID | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 9 | B |
| SYS | DESC_REC3 | DBMS_SQL | COL_SCALE | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 8 | B |
| SYS | DESC_REC3 | DBMS_SQL | COL_PRECISION | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 7 | B |
| SYS | DESC_REC3 | DBMS_SQL | COL_SCHEMA_NAME_LEN | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 6 | B |
| SYS | DESC_REC3 | DBMS_SQL | COL_SCHEMA_NAME | NULL | NULL | VARCHAR2 | NULL | 32 | 2 | -1 | CHAR_CS | 5 | B |
| SYS | DESC_REC3 | DBMS_SQL | COL_NAME_LEN | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 4 | B |
| SYS | DESC_REC3 | DBMS_SQL | COL_NAME | NULL | NULL | VARCHAR2 | NULL | 32767 | 2 | -1 | CHAR_CS | 3 | B |
| SYS | DESC_REC3 | DBMS_SQL | COL_MAX_LEN | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 2 | B |
| SYS | DESC_REC3 | DBMS_SQL | COL_TYPE | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 1 | B |
| SYS | DESC_REC2 | DBMS_SQL | COL_NULL_OK | NULL | NULL | NUMBER | NULL | -1 | 1 | 0 | CHAR_CS | 11 | C |
| SYS | DESC_REC2 | DBMS_SQL | COL_CHARSETFORM | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 10 | B |
| SYS | DESC_REC2 | DBMS_SQL | COL_CHARSETID | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 9 | B |
| SYS | DESC_REC2 | DBMS_SQL | COL_SCALE | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 8 | B |
| SYS | DESC_REC2 | DBMS_SQL | COL_PRECISION | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 7 | B |
| SYS | DESC_REC2 | DBMS_SQL | COL_SCHEMA_NAME_LEN | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 6 | B |
| SYS | DESC_REC2 | DBMS_SQL | COL_SCHEMA_NAME | NULL | NULL | VARCHAR2 | NULL | 32 | 2 | -1 | CHAR_CS | 5 | B |
| SYS | DESC_REC2 | DBMS_SQL | COL_NAME_LEN | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 4 | B |
| SYS | DESC_REC2 | DBMS_SQL | COL_NAME | NULL | NULL | VARCHAR2 | NULL | 32767 | 2 | -1 | CHAR_CS | 3 | B |
| SYS | DESC_REC2 | DBMS_SQL | COL_MAX_LEN | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 2 | B |
| SYS | DESC_REC2 | DBMS_SQL | COL_TYPE | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 1 | B |
| SYS | DESC_REC | DBMS_SQL | COL_NULL_OK | NULL | NULL | NUMBER | NULL | -1 | 1 | 0 | CHAR_CS | 11 | C |
| SYS | DESC_REC | DBMS_SQL | COL_CHARSETFORM | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 10 | B |
| SYS | DESC_REC | DBMS_SQL | COL_CHARSETID | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 9 | B |
| SYS | DESC_REC | DBMS_SQL | COL_SCALE | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 8 | B |
| SYS | DESC_REC | DBMS_SQL | COL_PRECISION | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 7 | B |
| SYS | DESC_REC | DBMS_SQL | COL_SCHEMA_NAME_LEN | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 6 | B |
| SYS | DESC_REC | DBMS_SQL | COL_SCHEMA_NAME | NULL | NULL | VARCHAR2 | NULL | 32 | 2 | -1 | CHAR_CS | 5 | B |
| SYS | DESC_REC | DBMS_SQL | COL_NAME_LEN | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 4 | B |
| SYS | DESC_REC | DBMS_SQL | COL_NAME | NULL | NULL | VARCHAR2 | NULL | 32 | 2 | -1 | CHAR_CS | 3 | B |
| SYS | DESC_REC | DBMS_SQL | COL_MAX_LEN | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 2 | B |
| SYS | DESC_REC | DBMS_SQL | COL_TYPE | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 1 | B |
| SYS | INSTANCE_RECORD | DBMS_UTILITY | INST_NAME | NULL | NULL | VARCHAR2 | NULL | 60 | 2 | -1 | CHAR_CS | 2 | B |
| SYS | INSTANCE_RECORD | DBMS_UTILITY | INST_NUMBER | NULL | NULL | NUMBER | NULL | -1 | -1 | -85 | CHAR_CS | 1 | B |
| SYS | CONNECTION | UTL_TCP | PRIVATE_SD | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 8 | B |
| SYS | CONNECTION | UTL_TCP | TX_TIMEOUT | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 7 | B |
| SYS | CONNECTION | UTL_TCP | NEWLINE | NULL | NULL | VARCHAR2 | NULL | 2 | 2 | -1 | CHAR_CS | 6 | B |
| SYS | CONNECTION | UTL_TCP | CHARSET | NULL | NULL | VARCHAR2 | NULL | 30 | 2 | -1 | CHAR_CS | 5 | B |
| SYS | CONNECTION | UTL_TCP | LOCAL_PORT | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 4 | B |
| SYS | CONNECTION | UTL_TCP | LOCAL_HOST | NULL | NULL | VARCHAR2 | NULL | 255 | 2 | -1 | CHAR_CS | 3 | B |
| SYS | CONNECTION | UTL_TCP | REMOTE_PORT | NULL | NULL | NUMBER | NULL | -1 | 11 | 0 | CHAR_CS | 2 | B |
| SYS | CONNECTION | UTL_TCP | REMOTE_HOST | NULL | NULL | VARCHAR2 | NULL | 255 | 2 | -1 | CHAR_CS | 1 | B |
+-------+-----------------------------+--------------+---------------------+---------------+-----------------+-----------------------------------+-------------------+-----------+-----------+-------+--------------------+---------+-----------+
64 rows in set (0.155 sec)
References
- Query overall information about record types defined in packages: ALL_PLSQL_TYPE_ATTRS.
- Query overall information about record types defined in the current user's package: USER_PLSQL_TYPE_ATTRS.