深圳全飞鸿

标题: oracle 假游标? for [打印本页]

作者: foxe5 时间: 2019-6-10 11:17
标题: oracle 假游标? for
FOR wj IN (SELECT invoice,
                     TO_CHAR (finish_date, 'YYYY-MM-DD HH24:MI:SS') bb,
                     ROUND ((SYSDATE - finish_date) * 24) cc
               FROM sfism4.r_bpcs_invoice_t
               WHERE finish_date IS NOT NULL
               AND finish_date > SYSDATE - 10
               AND finish_date < SYSDATE - 4 / 24
               AND    nvl(ext_no,'n')<>'Y'
               AND model_name IN (
                        SELECT model_name
                        FROM sfis1.c_model_desc_t
                        WHERE model_type LIKE '%221%'
                           OR model_type LIKE '%232%'
                           OR model_type LIKE '%194%'
                           OR model_type LIKE '%187%'
                           OR model_type LIKE '%189%'
                           OR model_type LIKE '%209%'
                           OR model_type LIKE '%213%'
                           OR model_type LIKE '%210%')
            ORDER BY bb)
LOOP

   c_count := c_count + 1;

   IF (c_count < 11)
   THEN
      c_str :=
            c_str
         || wj.invoice
         || '    '
         || wj.bb
         || '    超時'
         || wj.cc
         || '小時'
         || CHR (13)
         || CHR (10);

      IF (wj.cc > 12)
      THEN
         c_stra :=
               c_stra
            || wj.invoice
            || '    '
            || wj.bb
            || '    超時'
            || wj.cc
            || '小時'
            || CHR (13)
            || CHR (10);
      END IF;
   ELSE
      c_str := c_str || '.';
   END IF;
END LOOP;

欢迎光临深圳全飞鸿 (http://www.nagomes.com/disc/)