일괄 ALTER 스크립트

SELECT 'ALTER TABLE '||TABLE_NAME||' MODIFY '||COLUMN_NAME||' NUMBER(5);'
       , 'UPDATE '||TABLE_NAME||' SET  '||COLUMN_NAME||' = NULL;'
       , TABLE_NAME , (SELECT COMMENTS FROM ALL_TAB_COMMENTS WHERE OWNER = B.OWNER AND TABLE_NAME = B.TABLE_NAME ) TABLE_COMMENTS
       , B.DATA_TYPE, B.DATA_LENGTH
  FROM ALL_TAB_COLUMNS B
WHERE OWNER = 'USER_NAME'
  AND ( COLUMN_NAME LIKE '%COLUMN_NAME' OR COLUMN_NAME LIKE '%COLUMN_NAME' ' )
  AND TABLE_NAME LIKE 'C%'
  AND TABLE_NAME NOT LIKE '%DIA_SQ%'