想对表中一个列属性进行修改,下面是我写的过程
编译通过,执行也没有问题,但是不出结果
create or replace procedure haso
as
ha number(10):=45;
CURSOR mycursor is select gdls from ines_vc_ibss where state=0 for UPDATE OF gdls;
begin
open mycursor;
WHILE mycursor%FOUND LOOP
ha:=ha+1;UPDATE ines_vc_ibss set gdls=ha;
end loop;
close mycursor;
commit;
end;
编译通过,执行也没有问题,但是不出结果
create or replace procedure haso
as
ha number(10):=45;
CURSOR mycursor is select gdls from ines_vc_ibss where state=0 for UPDATE OF gdls;
begin
open mycursor;
WHILE mycursor%FOUND LOOP
ha:=ha+1;UPDATE ines_vc_ibss set gdls=ha;
end loop;
close mycursor;
commit;
end;
CREATE OR REPLACE PROCEDURE HASO AS
HA NUMBER(10) := 45;
CURSOR MYCURSOR IS
SELECT GDLS FROM INES_VC_IBSS WHERE STATE = 0 FOR UPDATE OF GDLS;
BEGIN
FOR I IN MYCURSOR LOOP
HA := HA + 1;
UPDATE INES_VC_IBSS SET GDLS = HA WHERE CURRENT OF MYCURSOR;
END LOOP;
COMMIT;
END;
/
CREATE OR REPLACE PROCEDURE HASO AS
HA NUMBER(10) := 45;
CURSOR MYCURSOR IS
SELECT GDLS FROM INES_VC_IBSS WHERE STATE = 0 FOR UPDATE OF GDLS;
BEGIN
FOR I IN MYCURSOR LOOP
HA := HA + 1;
UPDATE INES_VC_IBSS SET GDLS = HA WHERE CURRENT OF MYCURSOR;
END LOOP;
COMMIT;
END;
/
for up_cur in ( select id from ines_vc_ibss where state=0 )
ha:=ha+1;
update ines_vc_ibss set gdls=ha where id = up_cur.id
commit;
end for;
HA NUMBER(10) := 45;
CURSOR MYCURSOR IS
SELECT GDLS FROM INES_VC_IBSS WHERE STATE = 0 FOR UPDATE;
BEGIN
FOR I IN MYCURSOR LOOP
HA := HA + 1;
UPDATE INES_VC_IBSS SET GDLS = HA WHERE CURRENT OF MYCURSOR;
END LOOP;
COMMIT;
END;