以下是我的存储过程的一部分:如何将取出的变量V_BBYRQ
的值插入到acc_yqdz表中的相应的字段中,以下红色的部分:
IS
BEGIN
DECLARE
V_DATE VARCHAR2( ;
V_BBYRQ VARCHAR2( ;
BEGIN
--取迁移日期值
SELECT SOU_DATE,SOU_BBYRQ INTO V_DATE,V_BBYRQ FROM SOURCE_DATE;
insert into acc_yqdz
select
a5sh,a5zh,a5bzh,a5gskm,a5rq,'V_BBYRQ','1',''
from(
select
a5sh,a5zh,a5bzh,a5gskm,a5rq,'','1',''
from whrept.aa5fhz
where (substr(a5gskm,1,3) in ('202','205','251')
or substr(a5gskm,1,3) in ('201','221'))
and a5bzh='01'
minus
select
a5sh,a5zh,a5bzh,a5gskm,a5rq,'',a8jd,''
from whrept.acc_yqdz
);
commit; |