The DBA_VIEW_COLUMNS view provides the information on all columns in the database.
Parameter | Type | Description |
---|---|---|
owner | CHARACTER VARYING | The username of the owner to which a view belongs. |
schema_name | CHARACTER VARYING | The name of the schema to which the view belongs. |
view_name | CHARACTER VARYING | The name of the 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 text columns. |
data_precision | NUMERIC | The precision of NUMBER columns. The precision is measured in the number of digits. |
data_scale | NUMERIC | The scale of NUMBER columns. |
nullable | CHARACTER(1) | Indicates whether the column can be null. Valid values:
|
column_id | NUMERIC | The relative position of a column within the view. |
data_default | CHARACTER VARYING | The default value assigned to the column. |