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_NESTED_TABLES

Object Details

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

Description of nested tables contained in the user's own tables

[View Source]

Columns

Name	Datatype	Length	Comments
TABLE_NAME	VARCHAR2	(128)	Name of the nested table
TABLE_TYPE_OWNER	VARCHAR2	(128)	Owner of the type of which the nested table was created
TABLE_TYPE_NAME	VARCHAR2	(128)	Name of the type of the nested table
PARENT_TABLE_NAME	VARCHAR2	(128)	Name of the parent table containing the nested table
PARENT_TABLE_COLUMN	VARCHAR2	(4000)	Column name of the parent table that corresponds to the nested table
STORAGE_SPEC	VARCHAR2	(30)
RETURN_TYPE	VARCHAR2	(20)
ELEMENT_SUBSTITUTABLE	VARCHAR2	(25)	Indication of whether the nested table element is substitutable or not

Query Text

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


SELECT TABLE_NAME
,      TABLE_TYPE_OWNER
,      TABLE_TYPE_NAME
,      PARENT_TABLE_NAME
,      PARENT_TABLE_COLUMN
,      STORAGE_SPEC
,      RETURN_TYPE
,      ELEMENT_SUBSTITUTABLE
FROM SYS.USER_NESTED_TABLES;

Dependencies

[top of page]

SYS.USER_NESTED_TABLES references the following:

SYS: ATTRCOL$; COL$; COLLECTION$; COLTYPE$; NTAB$; OBJ$; TYPE$; _BASE_USER; _CURRENT_EDITION_OBJ

SYS.USER_NESTED_TABLES is referenced by following:

PUBLIC: USER_NESTED_TABLES