set serveroutput on
Declare
v_nd int;
begin
select Max(IndiMoney) into v_nd from Indi_t_IndiBillDetail ;
v_nd:=nvl(v_nd,0);
if v_nd=0 then
v_nd:=1;
else
v_nd:=v_nd+1;
end if;
dbms_output.put_line(to_char(v_nd));
end;
注:oracle 的‘@’ 字符是默认的关键字,不能放在变量名里面;
Declare
v_nd int;
begin
select Max(IndiMoney) into v_nd from Indi_t_IndiBillDetail ;
v_nd:=nvl(v_nd,0);
if v_nd=0 then
v_nd:=1;
else
v_nd:=v_nd+1;
end if;
dbms_output.put_line(to_char(v_nd));
end;
注:oracle 的‘@’ 字符是默认的关键字,不能放在变量名里面;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货