17,086
社区成员
发帖
与我相关
我的任务
分享这个函数哪里错了？？？？？？
create or replace function phje(kjyf varchar2(7)) return integer
is
je number(15,2);
begin
select sum(n0008+n0009+n0011+n0013-n0010-n0012-n0014-n0037) into je from total_month where c0002=kjyf;
if je=0 then
return 1;
else
return 0;
end if;
end phje;
/
is
je number(15,2);
begin
select sum(n0008+n0009+n0011+n0013-n0010-n0012-n0014-n0037) into je from total_month where c0002=kjyf;
if je=0 then
return 1;
else
return 0;
end if;
end phje;
/
...全文
请发表友善的回复…
发表回复
gj_cong 2004-09-26
- 打赏
- 举报
学习！
bluelamb 2004-09-24
- 打赏
- 举报
参数不能指定大小
biliky 2004-09-24
- 打赏
- 举报
学习。
jack_4826 2004-09-24
- 打赏
- 举报
ok
deathangel 2004-09-24
- 打赏
- 举报
同意！
liuyi8903 2004-09-23
- 打赏
- 举报
create or replace function phje(kjyf varchar2(7)) return integer
改为
create or replace function phje(kjyf varchar2) return integer
改为
create or replace function phje(kjyf varchar2) return integer
bzszp 2004-09-23
- 打赏
- 举报
参数中只能说明类型，不能规定大小
enjun007 2004-09-23
- 打赏
- 举报
thank u very much;
wylwyl1130 2004-09-23
- 打赏
- 举报
create or replace function phje(kjyf varchar2) return integer
is
je number(15,2);
begin
select sum(n0008+n0009+n0011+n0013-n0010-n0012-n0014-n0037) into je from total_month where c0002=kjyf;
if je=0 then
return 1;
else
return 0;
end if;
end phje;
/
is
je number(15,2);
begin
select sum(n0008+n0009+n0011+n0013-n0010-n0012-n0014-n0037) into je from total_month where c0002=kjyf;
if je=0 then
return 1;
else
return 0;
end if;
end phje;
/
zhpsam109 2004-09-23
- 打赏
- 举报
学习！
