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

Object Details

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

Columns of user's tables, views and clusters

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes
TABLE_NAME	VARCHAR2	(128)	Yes	Table, view or cluster name
COLUMN_NAME	VARCHAR2	(128)	Yes	Column name
DATA_TYPE	VARCHAR2	(128)		Datatype of the column
DATA_TYPE_MOD	VARCHAR2	(3)		Datatype modifier of the column
DATA_TYPE_OWNER	VARCHAR2	(128)		Owner of the datatype of the column
DATA_LENGTH	NUMBER		Yes	Length of the column in bytes
DATA_PRECISION	NUMBER			Length: decimal digits (NUMBER) or binary digits (FLOAT)
DATA_SCALE	NUMBER			Digits to right of decimal point in a number
NULLABLE	VARCHAR2	(1)		Does column allow NULL values?
COLUMN_ID	NUMBER			Sequence number of the column as created
DEFAULT_LENGTH	NUMBER			Length of default value for the column
DATA_DEFAULT	LONG	(0)		Default value for the column
NUM_DISTINCT	NUMBER			The number of distinct values in the column
LOW_VALUE	RAW	(1000)		The low value in the column
HIGH_VALUE	RAW	(1000)		The high value in the column
DENSITY	NUMBER			The density of the column
NUM_NULLS	NUMBER			The number of nulls in the column
NUM_BUCKETS	NUMBER			The number of buckets in histogram for the column
LAST_ANALYZED	DATE			The date of the most recent time this column was analyzed
SAMPLE_SIZE	NUMBER			The sample size used in analyzing this column
CHARACTER_SET_NAME	VARCHAR2	(44)		Character set name
CHAR_COL_DECL_LENGTH	NUMBER			Declaration length of character type column
GLOBAL_STATS	VARCHAR2	(3)		Are the statistics calculated without merging underlying partitions?
USER_STATS	VARCHAR2	(3)		Were the statistics entered directly by the user?
AVG_COL_LEN	NUMBER			The average length of the column in bytes
CHAR_LENGTH	NUMBER			The maximum length of the column in characters
CHAR_USED	VARCHAR2	(1)		C if maximum length is specified in characters, B if in bytes
V80_FMT_IMAGE	VARCHAR2	(3)		Is column data in 8.0 image format?
DATA_UPGRADED	VARCHAR2	(3)		Has column data been upgraded to the latest type version format?
HISTOGRAM	VARCHAR2	(15)
DEFAULT_ON_NULL	VARCHAR2	(3)		Is this a default on null column?
IDENTITY_COLUMN	VARCHAR2	(3)		Is this an identity column?
EVALUATION_EDITION	VARCHAR2	(128)		Name of the evaluation edition assigned to the column expression
UNUSABLE_BEFORE	VARCHAR2	(128)		Name of the oldest edition in which the column is usable
UNUSABLE_BEGINNING	VARCHAR2	(128)		Name of the oldest edition in which the column becomes perpetually unusable

Query Text

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


SELECT OWNER
,      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
,      AVG_COL_LEN
,      CHAR_LENGTH
,      CHAR_USED
,      V80_FMT_IMAGE
,      DATA_UPGRADED
,      HISTOGRAM
,      DEFAULT_ON_NULL
,      IDENTITY_COLUMN
,      EVALUATION_EDITION
,      UNUSABLE_BEFORE
,      UNUSABLE_BEGINNING
FROM SYS.ALL_TAB_COLUMNS;

Dependencies

[top of page]

SYS.ALL_TAB_COLUMNS references the following:

SYS: ALL_TAB_COLS

SYS.ALL_TAB_COLUMNS is referenced by following:

APPS: AMS_LIST_RUNNING_TOTAL_PVT - show dependent code; AP_ACCTG_DATA_FIX_PKG - show dependent code; BEN_DM_CREATE_CONTROL_FILES - show dependent code; BEN_DM_GEN_DOWNLOAD - show dependent code; BEN_DM_GEN_UPLOAD - show dependent code; BEN_DM_UTILITY - show dependent code; CSC_PROFILE_VARIABLE_PVT - show dependent code; HZ_MERGE_DICTIONARY_PKG - show dependent code; HZ_PARTY_MERGE - show dependent code; HZ_PURGE - show dependent code; ZX_MIGRATE_REP_ENTITIES_PKG - show dependent code
PUBLIC: ALL_TAB_COLUMNS
SYS: ALL_APPLY_CONFLICT_COLUMNS; ALL_APPLY_KEY_COLUMNS; ALL_APPLY_TABLE_COLUMNS; ALL_REPCOLUMN; ALL_REPFLAVOR_COLUMNS; ALL_REPGROUPED_COLUMN; ALL_REPPARAMETER_COLUMN; ALL_SOURCE_TAB_COLUMNS; DBA_SOURCE_TAB_COLUMNS; DBMS_COMPARISON - show dependent code; DBMS_CUBE_LOG - show dependent code; DBMS_PICKLER - show dependent code; DBMS_REPCAT_CONF - show dependent code; DBMS_REPCAT_UTL - show dependent code; DBMS_SWRF_INTERNAL - show dependent code; DMP_SEC - show dependent code; PRVT_COMPRESSION - show dependent code; USER_PUBLISHED_COLUMNS; USER_SOURCE_TAB_COLUMNS; _ALL_REPCOLUMN; _ALL_REPGROUPED_COLUMN; _ALL_REPPARAMETER_COLUMN