- 论坛徽章:
- 0
|
v_str:='INSERT INTO rybo006mid1 ';
v_str:=v_str||' SELECT SUBSTR(c.org_code,1,2),SUBSTR(c.org_code,3,2),a.unit_id,a.id_no, ';
v_str:=v_str||' a.phone_no,prepay_fee,back_fee,b.login_no,a.op_time ';
v_str:=v_str||' FROM dddd a ,'||v_table_name||' b , Login c ';
v_str:=v_str||' WHERE a.id_no =b.id_no AND a.login_accept=b.login_accept ';
v_str:=v_str||' AND a.op_type=''8'' AND a.back_flag=''Y'' ';
v_str:=v_str||' AND b.op_code=''1336'' AND b.login_no=c.login_no ';
v_str:=v_str||' AND b.login_no=:bin_login_no ';
v_str:=v_str||' AND a.op_time >=:bin_begin_time ';
v_str:=v_str||' AND a.op_time <=:bin_end_time ';
EXECUTE IMMEDIATE v_str USING
rpad(in_login_no,6,' '),
to_date(in_begin_time,'yyyymmdd hh24:mi:ss'),
to_date(in_end_time,'yyyymmdd hh24:mi:ss'); |
|