PLSQL 10초마다 무한반복

2011-08-02 10:24:26

 

---

SQL 4 Oracle 오라클용 sql 실무

▒ PLSQL 10초마다 무한반복

 

declare
    find_tm  number := 0;
    find_cnt  number := 0;
begin
   WHILE 1=1 LOOP
    select mod(TO_CHAR(SYSDATE,'ss'),10) INTO find_tm from dual;
        if find_tm = 0 then
           select count(*) INTO find_cnt from 목적_Table where 최득일자=to_char(SYSDATE,'yyyymmdd') and 확인플레그='0'  ;
             if find_cnt > 5 then
                update 목적_Table set 확인플레그='1' where 최득일자=to_char(SYSDATE,'yyyymmdd') and 확인플레그='0' ;
                commit ;
             end if;
       end if;
END LOOP ;
end;