begin--如果客户号长度大于10则采用自编客户号
declare t_maxnum number;
t_maxnum:=0
select t_clientid=min(sclientid) from btc_clientinfo where sysclientno=0;
end;
要给t_maxnum赋值为0,但是上面那种写法是错误的,请问应该怎样写啊?
declare t_maxnum number;
t_maxnum:=0
select t_clientid=min(sclientid) from btc_clientinfo where sysclientno=0;
end;
要给t_maxnum赋值为0,但是上面那种写法是错误的,请问应该怎样写啊?
语法是这样子
declare
t_maxnum number:=0;
t_clientid number;
begin
select min(sclientid) into t_clientid= from btc_clientinfo where sysclientno=0;
end;
t_maxnum number:=0;
t_clientid number;
begin
select min(sclientid) into t_clientid from btc_clientinfo where sysclientno=0;
end;
declare
v_1 number:=0;----也可以在变量定义后赋值
begin
v_1:=23;
select count(*) into v_1 from emp;
end;