Table: COLS
Synonym for USER_TAB_COLUMNS
| Column Name | Description |
|---|---|
| AVG_COL_LEN | The average length of the column in bytes |
| CHARACTER_SET_NAME | Character set name |
| CHAR_COL_DECL_LENGTH | Declaration length of character type column |
| CHAR_LENGTH | The maximum length of the column in characters |
| CHAR_USED | C is maximum length given in characters, B if in bytes |
| COLUMN_ID | Sequence number of the column as created |
| COLUMN_NAME | Column name |
| DATA_DEFAULT | Default value for the column |
| DATA_LENGTH | Length of the column in bytes |
| DATA_PRECISION | Length: decimal digits (NUMBER) or binary digits (FLOAT) |
| DATA_SCALE | Digits to right of decimal point in a number |
| DATA_TYPE | Datatype of the column |
| DATA_TYPE_MOD | Datatype modifier of the column |
| DATA_TYPE_OWNER | Owner of the datatype of the column |
| DATA_UPGRADED | Has column data been upgraded to the latest type version format? |
| DEFAULT_LENGTH | Length of default value for the column |
| DENSITY | The density of the column |
| GLOBAL_STATS | Are the statistics calculated without merging underlying partitions? |
| HIGH_VALUE | The high value in the column |
| LAST_ANALYZED | The date of the most recent time this column was analyzed |
| LOW_VALUE | The low value in the column |
| NULLABLE | Does column allow NULL values? |
| NUM_BUCKETS | The number of buckets in histogram for the column |
| NUM_DISTINCT | The number of distinct values in the column |
| NUM_NULLS | The number of nulls in the column |
| SAMPLE_SIZE | The sample size used in analyzing this column |
| TABLE_NAME | Table, view or cluster name |
| USER_STATS | Were the statistics entered directly by the user? |
| V80_FMT_IMAGE | Is column data in 8.0 image format? |