请问以下过程有哪些错误?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?向各位高手求教?
- oracle817安装失败!
- 求救
- 怎么把文本文档批量导入oracle
- 建立临时表用来更新数据--怎么理解
- 如何实现oracle9i开机时和定时数据库自动备份???请各位高手帮忙
- 急需!我要下载一些有关,惠谱型号为(HP PROLIANT ML 570)的硬件资料。还有关集群设置,双机容错(热备份)及基本配置单总过程(是用WIN
- 用exp表时出现的问题
- oracle中账户如何自己提权获取create table权限
- 存储过程中传一个参数给其中的select .... where dept in(参数)
- 各位大侠请帮忙~急!!!关于日期输出显示的问题
也提示有误!
呢?
查找5040开头的字符串
5040
504001
504002
305040
315040是不是like '5040%'?