eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.USER_TYPE_ATTRS

Object Details

Object Name:	USER_TYPE_ATTRS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Description of attributes of the user's own types

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TYPE_NAME	VARCHAR2	(128)	Yes	Name of the type
ATTR_NAME	VARCHAR2	(128)	Yes	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	(128)		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)		Character set name of the attribute
ATTR_NO	NUMBER		Yes	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)
INHERITED	VARCHAR2	(3)		Is the attribute inherited from the supertype ?

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TYPE_NAME
,      ATTR_NAME
,      ATTR_TYPE_MOD
,      ATTR_TYPE_OWNER
,      ATTR_TYPE_NAME
,      LENGTH
,      PRECISION
,      SCALE
,      CHARACTER_SET_NAME
,      ATTR_NO
,      INHERITED
FROM SYS.USER_TYPE_ATTRS;

Dependencies

[top of page]

SYS.USER_TYPE_ATTRS references the following:

SYS: ATTRIBUTE$; TYPE$; USER$; _CURRENT_EDITION_OBJ

SYS.USER_TYPE_ATTRS is referenced by following:

PUBLIC: USER_TYPE_ATTRS