Question

oracle存储过程中怎么把参数传入表名中

create or replace procedure SZ_YM_HWLTJHZ (s_date in varchar2)
as
v_date varchar2(6);
v_day varchar2(2);
v_month varchar2(2);
v_sql varchar2;

begin
v_date:=substr(s_date,1,6);
v_day:=substr(s_date,7,2);
v_month:=substr(s_date,5,2);

v_sql:='insert into sz_ym_hwltj_'||v_date||

'(
-----市话
select 'sh','朔州新局D1',start_date,count(distinct msisdn),count(*),sum

(discount_cfee)/1000,sum(trunc((call_duration+59)/60)) from
(select * from ucr_sz1.tg_cdr||v_month_fix@dblnk_ngbil
union all
select * from ucr_sz2.tg_cdr||v_month_fix@dblnk_ngbil)
where msc in ('34917','34918')
and reserver1 in

(110,112,113,114,115,123,125,128,129,160,161,163,164,165,170,172,173,178,

350,352,354,356,358,311,312,314,316,304)
and trunk_groupin in ('0203','0205') and

partition_id=v_day
group by start_date
)';
EXECUTE IMMEDIATE V_SQL;
commit;
end SZ_YM_HWLTJHZ;
高手给看看哪里有问题，怎么改，我想把参数传入表名中

Answer 1

这样试试：

v_sql:='insert into sz_ym_hwltj_'||v_date||

'(
-----市话
select ''sh'',''朔州新局D1'',start_date,count(distinct msisdn),count(*),sum

(discount_cfee)/1000,sum(trunc((call_duration+59)/60)) from
(select * from ucr_sz1.tg_cdr||v_month_fix@dblnk_ngbil
union all
select * from ucr_sz2.tg_cdr||v_month_fix@dblnk_ngbil)
where msc in (''34917'',''34918'')
and reserver1 in

(110,112,113,114,115,123,125,128,129,160,161,163,164,165,170,172,173,178,

350,352,354,356,358,311,312,314,316,304)
and trunk_groupin in (''0203'',''0205'') and

partition_id=v_day
group by start_date
)';

追问

不好意思，我没看出来改了哪里，而且替换以后依旧不行

追答

把你的 字符中的 一个单引号，改成了 2个单引号，

保证你 的 最后的sql语句 的 字符值 是用单引号引起来的。

追问

嗯，现在可以了，谢谢了