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:
  • Y: indicates that the column can be null.
  • N: indicates that the column cannot be null.
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.