The ALL_TAB_COLUMNS view provides the information on all columns in all user-defined tables and views.
| Parameter | Type | Description |
|---|---|---|
| owner | CHARACTER VARYING | The username of the owner of the table or view where the column is located. |
| schema_name | CHARACTER VARYING | The name of the schema to which the table or the view belongs. |
| 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 columns. |
| data_precision | NUMERIC | The precision of the NUMBER column. The precision is measured with the number of digits. |
| data_scale | NUMERIC | The scale of the NUMBER columns. |
| nullable | CHARACTER(1) | Whether the column can be nullable. Valid values:
|
| column_id | NUMERIC | The relative position of the column within the table or view. |
| data_default | CHARACTER VARYING | The default value assigned to the column. |