请大神帮忙把这两段sql语句写入一个存储过程里,并且把表名设为变量,因为每次执行这段语句需要修改表名table_11 ,谢谢
select * from tab1 for update
create table tab_11 as
select *
from v_number
where pcode = 20161408
and scode in
(select scode from tab1)
delete from v_number
where = 20161408
and scode in
(select scode from tab1)
---285
insert into v_number
select 20161408,
a.scode,
a.ICODE,
from v_number a
where (a.pcode ,a.scode) in (select copy,scode from tab1)
delete from r_item
where pcode = 20161408
and scode in
(select scode from tab1)
insert into r_item
select 20161408, scode, percent
from r_item
where (pcode , scode) in
(select copy,scode from tab1)
select * from tab2 for update
create table tab2_20161408 as
select * from ra_number where pcode=20161408
and (scode,cy) in (select scode,cy from tab2)
delete from ra_number where pcode=20161408
and (scode,cy) in (select scode,cy from tab2)
insert into ra_number
select 20161408,
a.scode,
a.ITEMCODE
from ra_number a where (a.pcode,a.scode,a.cy) in
(select copy,scode,cy from tab2)
insert into v_number
select 20161408,
a.scode,
a.ICODE,
from v_number a
where (a.pcode ,a.scode) in (select copy,scode from tab2)