SELECT 'ALTER TABLE '||OWNER||'.'||TABLE_NAME||' MODIFY ('||COLUMN_NAME||' CHAR('||
DATA_LENGTH||'));' col
FROM all_tab_columns
WHERE owner='SCOTT' AND data_type=upper('VARCHAR2');
SELECT 'ALTER TABLE '||OWNER||'.'||TABLE_NAME||' MODIFY ('||COLUMN_NAME||' CHAR('||
DATA_LENGTH||'));' col
FROM all_tab_columns
WHERE owner='SCOTT' AND data_type=upper('VARCHAR2');