The DBA_TAB_COLUMNS view provides the information about all columns in the database.
Parameter | Type | Description |
owner | CHARACTER VARYING | The username of the owner of a table or view to which the column belongs. |
schema_name | CHARACTER VARYING | The name of the schema to which a table or view belongs. |
table_name | CHARACTER VARYING | The name of the table or view to which the column belongs. |
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 the NUMBER column. The precision is measured in the number of digits. |
data_scale | NUMERIC | The scale of the NUMBER columns. |
nullable | CHARACTER(1) | Indicates whether the column can be null. 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. |
default_length | INTEGER | The default length. |
data_type_owner | TEXT | The owner of the data type. |
char_length | NUMERIC | The character length. |
data_semantics | TEXT | The semantics of the character. |