The ALL_TAB_COLUMNS view provides the information on all columns in all user-defined tables and views.

Parameter Type Description
owner CHARACTER VARYING The username of the owner of the table or view where the column is located.
schema_name CHARACTER VARYING The name of the schema to which the table or the view belongs.
table_name CHARACTER VARYING The name of the table or 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 the text columns.
data_precision NUMERIC The precision of the NUMBER column. The precision is measured with the number of digits.
data_scale NUMERIC The scale of the NUMBER columns.
nullable CHARACTER(1) Whether the column can be nullable. Valid values:
  • Y: The column can be null.
  • N: 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.