ALL_TAB_COLUMNS v11
The ALL_TAB_COLUMNS view provides information on all columns in all user-defined tables and views.
| Name | Type | Description |
|---|---|---|
owner | CHARACTER VARYING | User name of the owner of the table or view in which the column resides. |
schema_name | CHARACTER VARYING | Name of the schema in which the table or view resides. |
table_name | CHARACTER VARYING | Name of the table or view. |
column_name | CHARACTER VARYING | Name of the column. |
data_type | CHARACTER VARYING | Data type of the column. |
data_length | NUMERIC | Length of text columns. |
data_precision | NUMERIC | Precision (number of digits) for NUMBER columns. |
data_scale | NUMERIC | Scale of NUMBER columns. |
nullable | CHARACTER(1) | Whether or not the column is nullable. Possible values are: Y – column is nullable; N – column does not allow null. |
column_id | NUMERIC | Relative position of the column within the table or view. |
data_default | CHARACTER VARYING | Default value assigned to the column. |