VIEW: SYS.CDB_TAB_COLS

Source

View Text - Preformatted

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","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 CONTAINERS("SYS"."DBA_TAB_COLS")

View Text - HTML Formatted

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"
, "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 CONTAINERS("SYS"."DBA_TAB_COLS")