批量生成批改表结构VARCHAR长度为3倍的命令

批量生成修改表结构VARCHAR长度为3倍的命令set heading offset feedback offset echo offspool c:\expo

批量生成修改表结构VARCHAR长度为3倍的命令

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;