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.EXU9COO_TTS_UNUSED_COL

Object Details

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

[View Source]

Columns

Name	Datatype	Length
TOBJID	NUMBER
TOWNER	VARCHAR2	(128)
TOWNERID	NUMBER
TNAME	VARCHAR2	(128)
NAME	VARCHAR2	(128)
LENGTH	NUMBER
PRECISION	NUMBER
SCALE	NUMBER
TYPE	NUMBER
ISNULL	NUMBER
CONNAME	VARCHAR2	(128)
COLID	NUMBER
INTCOLID	NUMBER
SEGCOLID	NUMBER
COMMENT$	VARCHAR2	(4000)
DEFAULT$	LONG	(0)
DFLTLEN	NUMBER
ENABLED	NUMBER
DEFER	NUMBER
FLAGS	NUMBER
COLPROP	NUMBER
ADTNAME	VARCHAR2	(128)
ADTOWNER	VARCHAR2	(128)
CHARSETID	NUMBER
CHARSETFORM	NUMBER
FSPRECISION	NUMBER
LFPRECISION	NUMBER
CHARLEN	NUMBER
TFLAGS	NUMBER
TYPESYN	VARCHAR2	(128)

Query Text

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


SELECT TOBJID
,      TOWNER
,      TOWNERID
,      TNAME
,      NAME
,      LENGTH
,      PRECISION
,      SCALE
,      TYPE
,      ISNULL
,      CONNAME
,      COLID
,      INTCOLID
,      SEGCOLID
,      COMMENT$
,      DEFAULT$
,      DFLTLEN
,      ENABLED
,      DEFER
,      FLAGS
,      COLPROP
,      ADTNAME
,      ADTOWNER
,      CHARSETID
,      CHARSETFORM
,      FSPRECISION
,      LFPRECISION
,      CHARLEN
,      TFLAGS
,      TYPESYN
FROM SYS.EXU9COO_TTS_UNUSED_COL;

Dependencies

[top of page]

SYS.EXU9COO_TTS_UNUSED_COL references the following:

SYS: COL$; COLTYPE$; EXU8COL_TEMP_TTS_UNUSED_COL; OBJ$; USER$

SYS.EXU9COO_TTS_UNUSED_COL is not referenced by any database object