sql实现简单自增长

create or replace package pkg_spgl is
     --获得商品编号
     function getSpBh(increment integer) return varchar2; 
       
end pkg_spgl;


create or replace package body pkg_spgl is
       function getSpBh(increment integer) return varchar2 is
         spbh  sp001.spbh%type;
       begin
           select to_char(nvl(max(a.spbh),0)+increment,'FM000') into spbh from jack.sp001 a ;
           return spbh;
       end;
end pkg_spgl;

insert into jack.sp001 values(jack.pkg_spgl.getSpBh(1),'可乐',2.5,30,null,'110000') ;

insert into jack.sp001 values(jack.pkg_spgl.getSpBh(1),'牛奶',3.5,50,null,'110000') ;

insert into jack.sp001 values(jack.pkg_spgl.getSpBh(1),'饼干',5,30,null,'110000') ;

insert into jack.sp001 values(jack.pkg_spgl.getSpBh(1),'蛋糕',100,10,null,'110000') ;