本人想得到下一个新的序号,新的序号是最大的序号加1而得到的,创建存储过程如下:
create or replace procedure get_net_xh
as
max_xh number;
next_xh number;
begin
select max(xh) into max_xh from leizhiyong_student ;
next_xh:=max_xh + 1;
dbms_output.put_line('next_xh='||next_xh);
end;
执行报错,请问要改哪里啊,谢谢
create or replace procedure get_net_xh
as
max_xh number;
next_xh number;
begin
select max(xh) into max_xh from leizhiyong_student ;
next_xh:=max_xh + 1;
dbms_output.put_line('next_xh='||next_xh);
end;
执行报错,请问要改哪里啊,谢谢
另外这个用seq不就行了
用max要考虑并发的问题