存储过程-f

create or replace PROCEDURE TASK_OPEN
IS
CNT NUMBER;
BEGIN    
     FOR C IN (SELECT * FROM TAB WHERE TNAME LIKE 'TASK_EMAILS%'  ORDER BY TNAME) LOOP         
             EXECUTE IMMEDIATE ' UPDATE '||C.TNAME||' SET OPEN=1 WHERE CLICK>=1 AND OPEN=0 '; 
             COMMIT;               
     END LOOP;
END;