这将需要与另外两个表进行联接，这两个表包含有关约束和所涉及的列的信息。
我把所有者限制在一个;你可能会想做相反的事情--删除你不感兴趣的用户，比如XNUMX、SYSTEM等。

SQL> select tab.owner as schema_name,
  2    tab.table_Name,
  3    col.column_name,
  4    col.data_type,
  5    col.data_precision,
  6    con.constraint_type
  7  from dba_tables tab join dba_tab_cols col on tab.owner = col.owner
  8                                           and tab.table_name = col.table_name
  9                      join dba_constraints con on con.owner = tab.owner
 10                                              and con.table_name = tab.table_name
 11                      join dba_cons_columns ccol on ccol.owner = con.owner
 12                                                and ccol.table_name = con.table_name
 13                                                and ccol.column_name = col.column_name
 14                                                and ccol.constraint_name = con.constraint_name
 15  where tab.owner in ('SCOTT')
 16    and col.data_type in ('NUMBER', 'BINARY_FLOAT', 'BINARY_DOUBLE', 'FLOAT')
 17    and con.constraint_type = 'U'
 18  order by tab.owner, tab.table_name, col.column_name;

SCHEMA_NAME TABLE_NAME  COLUMN_NAME DATA_TYPE       DATA_PRECISION CONSTRAINT_TYPE
----------- ----------- ----------- --------------- -------------- ---------------
SCOTT       TEMP_UNI    ID          NUMBER                         U
SCOTT       TEST2       ID          NUMBER                         U
SCOTT       TEST2       NAME        BINARY_FLOAT                   U

SQL>