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_PLSQL_TYPES

Object Details

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

Description of the user's own types

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TYPE_NAME	VARCHAR2	(136)		Name of the type
PACKAGE_NAME	VARCHAR2	(128)	Yes	Name of the package containing the type
TYPE_OID	RAW	(16)	Yes	Object identifier (OID) of the type
TYPECODE	VARCHAR2	(58)		Typecode of the type
ATTRIBUTES	NUMBER			Number of attributes (if any) in the type
CONTAINS_PLSQL	VARCHAR2	(3)		Does the type contain plsql specific data types?

Query Text

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


SELECT TYPE_NAME
,      PACKAGE_NAME
,      TYPE_OID
,      TYPECODE
,      ATTRIBUTES
,      CONTAINS_PLSQL
FROM SYS.USER_PLSQL_TYPES;

Dependencies

[top of page]

SYS.USER_PLSQL_TYPES references the following:

SYS: TYPE$; _CURRENT_EDITION_OBJ

SYS.USER_PLSQL_TYPES is referenced by following:

PUBLIC: USER_PLSQL_TYPES