为了一条条的对数据库操作，怎样生成update之类的DML语句

SELECT
'UPDATE TB1 SET '||
'COL_DCNT = '|| COL_DCNT ||
' WHERE KAISYACD = 1001001 AND '||
' KYUYONGT = '''|| COL1 ||''' AND '||
' COL2 = '''|| COL2 ||''';'
FROM
  (SELECT TO_CHAR(ADD_MONTHS(TO_DATE(COL1,'YYYYMM'),1),'YYYYMM') AS COL1,
          COL2               AS COL2,
          SUM(NVL(DCNT,0))     AS COL_DCNT,
    FROM  TB_TMM_CISKINMU_WK
    GROUP BY HOKOKUYM,SHABAN,TANKAKBN
   )