过程中动态建表的问题!!
我的过程如下,很简单的,但为什么老报错误!在第5行
create or replace procedure pro_temp
as
v_num number;
begin
execute immediate 'CREATE TABLE T_TEMP(COL1 number(10),Col2 number(10))';
execute immediate 'insert into t_temp values(1,1)';
execute immediate 'select col1 from t_temp' into v_num;
dbms_output.put_line(v_num);
execute immediate 'delete from t_temp';
commit;
execute immediate 'drop table t_temp';
end;
求答案
还有这个语句execute immediate 'insert into t_temp values('''v_col1''','''v_col2''')';
为什么那么多单引号才能插变量!!????急啊