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_TAB_COLS_V$

Object Details

Object Name:	USER_TAB_COLS_V$
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
TABLE_NAME	VARCHAR2	(128)	Yes
COLUMN_NAME	VARCHAR2	(128)	Yes
DATA_TYPE	VARCHAR2	(128)
DATA_TYPE_MOD	VARCHAR2	(3)
DATA_TYPE_OWNER	VARCHAR2	(128)
DATA_LENGTH	NUMBER		Yes
DATA_PRECISION	NUMBER
DATA_SCALE	NUMBER
NULLABLE	VARCHAR2	(1)
COLUMN_ID	NUMBER
DEFAULT_LENGTH	NUMBER
DATA_DEFAULT	LONG	(0)
NUM_DISTINCT	NUMBER
LOW_VALUE	RAW	(1000)
HIGH_VALUE	RAW	(1000)
DENSITY	NUMBER
NUM_NULLS	NUMBER
NUM_BUCKETS	NUMBER
LAST_ANALYZED	DATE
SAMPLE_SIZE	NUMBER
CHARACTER_SET_NAME	VARCHAR2	(44)
CHAR_COL_DECL_LENGTH	NUMBER
GLOBAL_STATS	VARCHAR2	(3)
USER_STATS	VARCHAR2	(3)
NOTES	VARCHAR2	(63)
AVG_COL_LEN	NUMBER
CHAR_LENGTH	NUMBER
CHAR_USED	VARCHAR2	(1)
V80_FMT_IMAGE	VARCHAR2	(3)
DATA_UPGRADED	VARCHAR2	(3)
HIDDEN_COLUMN	VARCHAR2	(3)
VIRTUAL_COLUMN	VARCHAR2	(3)
SEGMENT_COLUMN_ID	NUMBER
INTERNAL_COLUMN_ID	NUMBER		Yes
HISTOGRAM	VARCHAR2	(15)
QUALIFIED_COL_NAME	VARCHAR2	(4000)
USER_GENERATED	VARCHAR2	(3)
DEFAULT_ON_NULL	VARCHAR2	(3)
IDENTITY_COLUMN	VARCHAR2	(3)
EVALUATION_EDITION	VARCHAR2	(128)
UNUSABLE_BEFORE	VARCHAR2	(128)
UNUSABLE_BEGINNING	VARCHAR2	(128)

Query Text

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


SELECT TABLE_NAME
,      COLUMN_NAME
,      DATA_TYPE
,      DATA_TYPE_MOD
,      DATA_TYPE_OWNER
,      DATA_LENGTH
,      DATA_PRECISION
,      DATA_SCALE
,      NULLABLE
,      COLUMN_ID
,      DEFAULT_LENGTH
,      DATA_DEFAULT
,      NUM_DISTINCT
,      LOW_VALUE
,      HIGH_VALUE
,      DENSITY
,      NUM_NULLS
,      NUM_BUCKETS
,      LAST_ANALYZED
,      SAMPLE_SIZE
,      CHARACTER_SET_NAME
,      CHAR_COL_DECL_LENGTH
,      GLOBAL_STATS
,      USER_STATS
,      NOTES
,      AVG_COL_LEN
,      CHAR_LENGTH
,      CHAR_USED
,      V80_FMT_IMAGE
,      DATA_UPGRADED
,      HIDDEN_COLUMN
,      VIRTUAL_COLUMN
,      SEGMENT_COLUMN_ID
,      INTERNAL_COLUMN_ID
,      HISTOGRAM
,      QUALIFIED_COL_NAME
,      USER_GENERATED
,      DEFAULT_ON_NULL
,      IDENTITY_COLUMN
,      EVALUATION_EDITION
,      UNUSABLE_BEFORE
,      UNUSABLE_BEGINNING
FROM SYS.USER_TAB_COLS_V$;

Dependencies

[top of page]

SYS.USER_TAB_COLS_V$ references the following:

SYS: ATTRCOL$; COL$; COLTYPE$; HISTGRM$; HIST_HEAD$; OBJ$; TAB$; _BASE_USER; _CURRENT_EDITION_OBJ

SYS.USER_TAB_COLS_V$ is referenced by following:

SYS: USER_TAB_COLS; USER_TAB_COL_STATISTICS