set heading off;
set feedback off;    
set echo off;    
spool c:\export.sql;   
select  'ALTER TABLE ' || TABLE_NAME || ' MODIFY ' || COLUMN_NAME || ' VARCHAR2('|| DATA_LENGTH*3 ||');'  BATCH_MODIFY_VARCHAR from all_tab_columns where owner='IM-ADMIN' AND DATA_TYPE='VARCHAR2' AND DATA_LENGTH<1300 AND TABLE_NAME NOT LIKE 'TM_%'AND TABLE_NAME NOT LIKE 'TS_%'AND TABLE_NAME NOT LIKE 'OF%';   
spool off;