ORACLE PL/SQL CURSOR

最新推荐文章于 2025-04-22 17:02:59 发布

原创最新推荐文章于 2025-04-22 17:02:59 发布 · 109 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#SQL #Oracle #C #C++ #C#

DECLARE
   partyId VARCHAR2(20);                
   CURSOR c_party_group is select party_id from PARTY_GROUP;
   attrCount integer;
BEGIN
   OPEN c_party_group;
   LOOP
     FETCH c_party_group into partyId;
     exit when c_party_group%notfound;
     dbms_output.put_line(partyId);
     
     SELECT COUNT (*) INTO attrCount FROM PARTY_ATTRIBUTE WHERE PARTY_ID = partyId and attr_name = 'LEVEL';
     if attrCount = 0 then 
        insert into party_attribute (party_id, attr_name, attr_value) values (partyId, 'LEVEL', '4');
     end if;
   END LOOP;
   CLOSE c_party_group;
END;