USER_TAB_COLUMNS lists metadata for every column in tables and views owned by the current user.
| Column | Type | Description |
|---|---|---|
schema_name | CHARACTER VARYING | The schema that contains the table or view. |
table_name | CHARACTER VARYING | The name of the table or view. |
column_name | CHARACTER VARYING | The name of the column. |
data_type | CHARACTER VARYING | The data type of the column. |
data_length | NUMERIC | The length of the text column. |
data_precision | NUMERIC | The precision of NUMBER columns, measured in digits. |
data_scale | NUMERIC | The scale of NUMBER columns—the number of digits to the right of the decimal point. |
nullable | CHARACTER(1) | Whether the column accepts null values. Y – the column is nullable; N – the column does not allow null. |
column_id | NUMERIC | The ordinal position of the column within the table. |
data_default | CHARACTER VARYING | The default value assigned to the column. |