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

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
TNAME	VARCHAR2	(128)	Yes
COLNO	NUMBER		Yes
CNAME	VARCHAR2	(128)	Yes
COLTYPE	VARCHAR2	(265)
WIDTH	NUMBER		Yes
SCALE	NUMBER
PRECISION	NUMBER
NULLS	VARCHAR2	(19)
DEFAULTVAL	LONG	(0)
CHARACTER_SET_NAME	VARCHAR2	(44)

Query Text

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


SELECT TNAME
,      COLNO
,      CNAME
,      COLTYPE
,      WIDTH
,      SCALE
,      PRECISION
,      NULLS
,      DEFAULTVAL
,      CHARACTER_SET_NAME
FROM SYS.COL;

Dependencies

[top of page]

SYS.COL references the following:

SYS: COL$; COLTYPE$; OBJ$; _BASE_USER; _CURRENT_EDITION_OBJ

SYS.COL is referenced by following:

PUBLIC: COL
SYSTEM: COL