orcale变量很头疼,下面这个用法那里错了
Declare mm INTEGER;
begin
Select (NVL( a.MaxNum,0)+1) into mm from ( Select
max(NQ_REC_SEQ) as MaxNum from NS_NREC_HEAD where IPD_SEQ='0971120015')a ;
select mm from dual;
end;
(NVL( a.MaxNum,0)+1)查出来是1
Declare mm INTEGER;
begin
Select (NVL( a.MaxNum,0)+1) into mm from ( Select
max(NQ_REC_SEQ) as MaxNum from NS_NREC_HEAD where IPD_SEQ='0971120015')a ;
select mm from dual;
end;
(NVL( a.MaxNum,0)+1)查出来是1
这个不行
需要将mm into到某个变量中
你想看mm的值?
输出不就得了
dbms_output.put_line(mm);
那为什么不
Select NVL(max(NQ_REC_SEQ),0)+1 into mm from NS_NREC_HEAD where IPD_SEQ='0971120015'