create or replace procedure my_init_begin is
li_count Int ;
Begin
Select Count(*) Into li_count From sc_invo;
li_count = li_coun + 1 ;
insert into sc_invo (
SIB_BILLNO ,
SIB_SYJID,
SIB_SYJINVNO ,
SIB_SHOUGHTPAY ,
SIB_SENDDATE ,
SIB_CNAME,
SIB_SIGN ,
SIB_GRANTZR,
SIB_JS ,
SIB_UPDATE ,
SIB_COUPON ,
SIB_OTHER1 ,
SIB_OTHER2 )
select
li_count,
SIB_SYJID,
SIB_SYJINVNO ,
SIB_SHOUGHTPAY ,
SIB_SENDDATE ,
SIB_CNAME,
SIB_SIGN ,
SIB_GRANTZR,
SIB_JS ,
SIB_UPDATE ,
SIB_COUPON ,
SIB_OTHER1 ,
SIB_OTHER2from sc_invo_bak;
delete from sc_invo_bak ;
Commit ;
end my_init_begin;
|