DBA_TAB_COLUMNS v17
The DBA_TAB_COLUMNS
view provides information about all columns in the database.
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 in which the column resides. |
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 in the table or view. |
data_default | CHARACTER VARYING | Default value assigned to the column. |