Code:
select OWNER,TABLE_NAME,COLUMN_NAME
  from dba_tab_columns
 where DATA_TYPE='CLOB'
See also Metalink note 66320.1.