[Home] [Help]
[Dependency Information]
Object Name: | ALL_TAB_COLUMNS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Columns of user's tables, views and clusters
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 |
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;
|
|
|