user_tab_columns
, all_tab_columns
and dba_tab_columns
. dba_tab_columns
is related to dba_tab_cols
, the difference being that dba_tab_columns
only shows columns that are not generated, see differences between dba_tab_columns
and dba_tab_cols
dba_tab_columns
to select the structural differences between two tables. DATA_LENGTH
, DATA_PRECISION
and DATA_SCALE