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:
  • Y: indicates that the column can be null.
  • N: indicates that the column cannot be null.
column_id NUMERIC The relative position of a column within the view.
data_default CHARACTER VARYING The default value assigned to the column.