Static Data Dictionary Views, 96 of 452

ALL_TYPE_ATTRS

ALL_TYPE_ATTRS describes the attributes of object types accessible to the user.

USER_TYPE_ATTRS describes the attributes of all object types owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`		Owner of the type
`TYPE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the type
`ATTR_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the attribute
`ATTR_TYPE_MOD`	`VARCHAR2(7)`		Type modifier of the attribute
`ATTR_TYPE_OWNER`	`VARCHAR2(30)`		Owner of the type of the attribute
`ATTR_TYPE_NAME`	`VARCHAR2(30)`		Name of the type of the attribute
`LENGTH`	`NUMBER`		Length of the `CHAR` attribute or maximum length of the `VARCHAR` or `VARCHAR2` attribute
`PRECISION`	`NUMBER`		Decimal precision of the NUMBER or `DECIMAL` attribute or binary precision of the `FLOAT` attribute
`SCALE`	`NUMBER`		Scale of the `NUMBER` or `DECIMAL` attribute
`CHARACTER_SET _NAME`	`VARCHAR2(44)`		The name of the character set: `CHAR_CS` or `NCHAR_CS`
`ATTR_NO`	`NUMBER`	`NOT NULL`	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)