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, 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 all_tab_cols_v$
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
, 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 ALL_TAB_COLS_V$
|
|
|