반응형
SELECT 'ALTER TABLE ' || TABLE_NAME || ' MODIFY ' || COLUMN_NAME || ' ' || DATA_TYPE || '(' || DATA_LENGTH  || ' CHAR);' 
FROM ALL_TAB_COLUMNS 
WHERE DATA_TYPE IN ('VARCHAR2') AND OWNER = 'DB사용자이름'

 

+ Recent posts