home - keyword index

Table: USER_TAB_COLUMNS

Columns of user's tables, views and clusters

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?

home - keyword index

Comment on this page: