SQL> select owner, table_name, column_name
  2  from   dba_tab_columns
  3  where  data_type in ('CLOB','BLOB','BFILE')
  4  order by owner, table_name, column_name
  5  /

OWNER                          TABLE_NAME                     COLUMN_NAME
------------------------------ ------------------------------ ------------------
SYS                            ECOL$                          BINARYDEFVAL
SYS                            EDITION$                       CODE
SYS                            JIREFRESHSQL$                  SQLTEXT
SYS                            PDB_SYNC$                      LONGSQLTXT
SYS                            SQL$                           SPARE2
SYS                            SQL$TEXT                       SQL_TEXT
SYS                            SQLTXL_SQL$                    SQLTEXT
SYS                            SQLTXL_SQL$                    TXLTEXT
SYS                            VIEWCON$                       CON_TEXT
...
...
...