如何插入数据

godlight

create table nly_temp as
Select  t.lanid,t.city,Count(*) q  From ly_rateplan1027 t Where t.rpinstanceid In (
Select t.rpinstanceid From ly_rateplan1027 t Where t.rptype='套餐'
Minus
Select a.rateplanid From rateplan_tc_1129 a)
Group By t.lanid,t.city;
上面这个语句运行没问题
但是 写到过程里就说无效  估计是'套餐'这里不对了  但是试验改了好多次  都不行 求教啊
过程是
CREATE OR REPLACE PROCEDURE NLY_TEST_P AS
    current_date        date;
BEGIN
EXECUTE IMMEDIATE  'create table nly_temp as
Select  t.lanid,t.city,Count(*) q  From ly_rateplan1027 t Where t.rpinstanceid In (
Select t.rpinstanceid From ly_rateplan1027 t Where t.rptype=||'\''||套餐||'\''||
Minus
Select a.rateplanid From rateplan_tc_1129 a)
Group By t.lanid,t.city';
end NLY_TEST_P;

ora_teacher

CREATE OR REPLACE PROCEDURE NLY_TEST_P AS
    current_date        date;
BEGIN
EXECUTE IMMEDIATE  'create table nly_temp as
Select  t.lanid,t.city,Count(*) q  From ly_rateplan1027 t Where t.rpinstanceid In (
Select t.rpinstanceid From ly_rateplan1027 t Where t.rptype=''套餐''
Minus
Select a.rateplanid From rateplan_tc_1129 a)
Group By t.lanid,t.city';
end NLY_TEST_P;

godlight

哦  ～  晕  忘了这么写   多谢