DBA_TAB_COLUMNS

DBA_TAB_COLUMNS stores the columns of tables and views. Each column of a table in the database has a row in DBA_TAB_COLUMNS. Only users with system administrator permissions can access this view.

Name	Type	Description
owner	character varying(64)	Owner of a table/view
table_name	character varying(64)	Table/View name
column_name	character varying(64)	Column name
data_type	character varying(128)	Data type of the column
column_id	integer	Sequence number of the column when a table/view is created
data_length	integer	Length of the column, in bytes
comments	text	Comments
avg_col_len	numeric	Average length of a column, in bytes
nullable	bpchar	Whether the column can be empty. For the primary key constraint and non-null constraint, the value is n.
data_precision	integer	Precision of the data type. This parameter is valid for the numeric data type and NULL for other data types.
data_scale	integer	Number of decimal places. This parameter is valid for the numeric data type and 0 for other data types.
char_length	numeric	Length of a column, in characters. This parameter is valid only for the varchar, nvarchar2, bpchar, and char types.
schema	character varying(64)	Namespace that contains the table or view.
kind	text	Type of the current record. If the column belongs to a table, the value of this column is table. If the column belongs to a view, the value of this column is view.