Table: DBA_TYPE_ATTRS
Description of attributes of all types in the database
| Column Name | Description |
|---|---|
| ATTR_NAME | Name of the attribute |
| ATTR_NO | Syntactical order number or position of the attribute as specified in the type specification or CREATE TYPE statement (not to be used as ID number) |
| ATTR_TYPE_MOD | Type modifier of the attribute |
| ATTR_TYPE_NAME | Name of the type of the attribute |
| ATTR_TYPE_OWNER | Owner of the type of the attribute |
| CHARACTER_SET_NAME | Character set name of the attribute |
| INHERITED | Is the attribute inherited from the supertype ? |
| LENGTH | Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute |
| OWNER | Owner of the type |
| PRECISION | Decimal precision of the NUMBER or DECIMAL attribute or binary precision of the FLOAT attribute |
| SCALE | Scale of the NUMBER or DECIMAL attribute |
| TYPE_NAME | Name of the type |