3.11 ALL_PLSQL_TYPE_ATTRS

ALL_PLSQL_TYPE_ATTRS describes the attributes of PL/SQL types accessible to the user.

Related Views

• DBA_PLSQL_TYPE_ATTRS describes the attributes of all PL/SQL types in the database.

• USER_PLSQL_TYPE_ATTRS describes the attributes of the user's own PL/SQL types. This view does not display the OWNER or CHAR_USED columns.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(128)		Owner of the type
TYPE_NAME	VARCHAR2(136)		Name of the type
PACKAGE_NAME	VARCHAR2(128)		Name of the package containing the type
ATTR_NAME	VARCHAR2(128)		Name of the attribute
ATTR_TYPE_MOD	VARCHAR2(7)		Type modifier of the attribute
ATTR_TYPE_OWNER	VARCHAR2(128)		Owner of the type of the attribute
ATTR_TYPE_NAME	VARCHAR2(136)		Name of the type of the attribute
ATTR_TYPE_PACKAGE	VARCHAR2(128)		Name of the package containing the attribute type
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)		Character set name of the attribute
ATTR_NO	NUMBER		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)
CHAR_USED	VARCHAR2(1)		C if the width was specified in characters, B if in bytes

See Also:

• "DBA_PLSQL_TYPE_ATTRS"

• "USER_PLSQL_TYPE_ATTRS"