DBA_TAB_COLUMNS describes all columns across all tables and views in the database.
Column reference
| Column | Type | Null | Description |
|---|---|---|---|
owner | CHARACTER VARYING | The username of the owner of the table or view that contains the column. | |
schema_name | CHARACTER VARYING | The name of the schema that contains the table or view. | |
table_name | CHARACTER VARYING | The name of the table or view that contains the column. | |
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 text columns. | |
data_precision | NUMERIC | The precision of NUMBER columns, 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 — nullable; N — not nullable. | |
column_id | NUMERIC | The ordinal position of the column within the table or view. | |
data_default | CHARACTER VARYING | The default value assigned to the column. | |
default_length | INTEGER | The default length. | |
data_type_owner | TEXT | The owner of the column's data type. | |
char_length | NUMERIC | The character length. | |
data_semantics | TEXT | The character semantics of the column. |