select 'alter table '||table_name||' modify '||column_name||' '||data_type||'('||data_length||' char);'
from USER_TAB_COLUMNS
where data_type='VARCHAR2'
and table_name in(select table_name from USER_ALL_TABLES)
转载于:https://www.cnblogs.com/jony413/archive/2012/08/20/2648160.html