Oracle 存储过程 循环例子

-- 第一步：先定义存储过程
CREATE OR REPLACE PROCEDURE MY_GEN_UUID IS
    BEGIN
      DECLARE
        CURSOR DATACUR IS
         select rid from TB_TJ_RADHETH where uuid is null;
      BEGIN
        FOR DATACUR_ROW IN DATACUR LOOP
          update TB_TJ_RADHETH SET UUID = (select  RAWTOHEX(sys_guid())  uuid  from  dual) WHERE RID = DATACUR_ROW.RID;
        END LOOP;
      END;
    END MY_GEN_UUID;
        
        
-- 第二步：执行存储过程
CALL MY_GEN_UUID();