请问以下过程有哪些错误?CREATE OR REPLACE PROCEDURE "SYSTEM"."UPDATE_SUBJECTTYPE"
as
cursor signcursor is
select * from system.A;
errormessage exception;
accountrecord system.A%rowtype;
acccountsign varchar2(10);
s number;
accountnumber varchar2(50);begin
open signcursor;
if signcursor%notfound then
raise errormessage;
end if;
loop
fetch signcursor into accountrecord;
accountnumber :=accountrecord.ACCOUNT_NUMBER;
s := select count(*) from system.A where A.ACCOUNT_NUMBER like accountnumber and ACCOUNT_NUMBER!=accountrecord.ACCOUNT_NUMBER;/*提示有误!*/
if ( s = 0) then
acccountsign:='leaf';
else
acccountsign:='notleaf';
end if;
exit when signcursor%notfound;
update system.A set sign = acccountsign where ACCOUNT_NUMBER =accountrecord.ACCOUNT_NUMBER ;
end loop;
close signcursor;
commit;
end;
as
cursor signcursor is
select * from system.A;
errormessage exception;
accountrecord system.A%rowtype;
acccountsign varchar2(10);
s number;
accountnumber varchar2(50);begin
open signcursor;
if signcursor%notfound then
raise errormessage;
end if;
loop
fetch signcursor into accountrecord;
accountnumber :=accountrecord.ACCOUNT_NUMBER;
s := select count(*) from system.A where A.ACCOUNT_NUMBER like accountnumber and ACCOUNT_NUMBER!=accountrecord.ACCOUNT_NUMBER;/*提示有误!*/
if ( s = 0) then
acccountsign:='leaf';
else
acccountsign:='notleaf';
end if;
exit when signcursor%notfound;
update system.A set sign = acccountsign where ACCOUNT_NUMBER =accountrecord.ACCOUNT_NUMBER ;
end loop;
close signcursor;
commit;
end;
解决方案 »
- oracle 数据保存的问题
- 【求】一条SQL语句,小计,汇总相关
- oracle 816 for windows 2000 到 oracle 816 for windows 2003 可以吗?
- oracle 排序 rownum
- 如何实现在函数中返回表???
- 重建控制文件时,出现ORA-00600错误,急!!
- 在查询表时,我想把表名最后一位是数字的表查询出来
- sql2000通过发布向异类数据库oracle强制订阅的时候出现ora-00955错误。
- Oracle中怎样插入一条记录到某条记录之前?
- 请问我从oracle网站上下了一个oracle9,请问这需要注册码?谢谢了,初次来,放点分!
- 存储过程中传一个参数给其中的select .... where dept in(参数)
- 各位大侠请帮忙~急!!!关于日期输出显示的问题
也提示有误!
呢?
查找5040开头的字符串
5040
504001
504002
305040
315040是不是like '5040%'?