想对表中一个列属性进行修改,下面是我写的过程
编译通过,执行也没有问题,但是不出结果
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;
解决方案 »
- 关于安装oracle9i for redhat9.0 字符集的问题。
- oracle 触发器 !!!!!!!!!
- ORA-00376错误。
- HibernateTemplate.Find 查询溢出
- 紧急求救!Oracle不能连接到远程服务器!
- 请问:怎样将数据包导入oracle环境。
- 初级的问题
- 关于表的设计,如何使用数据库表中的方案???
- 急!!在线等。我的数据库oracle817,字段为varchar2(4000),为什么最多只能装600多个汉字。
- pl/sql developer工具怎么查看包头和包体
- unix下的oracle 数据库启动
- case语句在sql, pl/sql的异同点。我犯错了,希望不要误导大家。散分100
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;