[Home] [Help] [Dependency Information]
Object Name: | CDB_TAB_COLS_V$ |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | |
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 | |||
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 | |||
HISTOGRAM | VARCHAR2 | (15) | ||
QUALIFIED_COL_NAME | VARCHAR2 | (4000) | ||
USER_GENERATED | VARCHAR2 | (3) | ||
DEFAULT_ON_NULL | VARCHAR2 | (3) | ||
IDENTITY_COLUMN | VARCHAR2 | (3) | ||
SENSITIVE_COLUMN | VARCHAR2 | (3) | ||
EVALUATION_EDITION | VARCHAR2 | (128) | ||
UNUSABLE_BEFORE | VARCHAR2 | (128) | ||
UNUSABLE_BEGINNING | VARCHAR2 | (128) | ||
CON_ID | NUMBER | container id |
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
, 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
, SENSITIVE_COLUMN
, EVALUATION_EDITION
, UNUSABLE_BEFORE
, UNUSABLE_BEGINNING
, CON_ID
FROM SYS.CDB_TAB_COLS_V$;
SYS.CDB_TAB_COLS_V$ does not reference any database object
SYS.CDB_TAB_COLS_V$ is not referenced by any database object
|
|
|