user_tab_column

HR/HR@ORCL

select distinct('select DBMS_METADATA.GET_DDL(''TABLE'',''' ||table_name|| ''') from DUAL;') a
from user_tab_columns where data_type in ('CLOB','BLOB','RAW','NCLOB')
order by a;

select DBMS_METADATA.GET_DDL('TABLE','IMAGE_01') from DUAL;