如果执行动态见表sql，sql中带参数

[hongchang1010]

create table t_tmp as (select * from t_app where flag=1 and name="ZJZX" and rownum <7 ) ;

[hongchang1010]

江湖救急啊 在线等

[hongchang1010]

v_sql_create:='create table t_tmp as (select * from t_app where flag=1 and name='||'''ZJZX'''||'and rownum <7 )';
execute immediate v_sql_create;

搞定了 ！谢谢各位

[weiyancheng1181]

v_change_sql :='create table t_tmp as (select * from t_app where flag=1 and name="ZJZX" and rownum <7 )' ;

execute immediate v_change_sql;

[junval]

begin
declare
v_what varchar2(200):='ZJZX'; --参数 这里使用楼主的表名了
v_sql varchar2(4000);
begin
v_sql :='create table t_tmp as (select * from t_app where flag=1 and name='||v_what||' and rownum <7 )' ;
execute immediate v_sql;
exception when others then
null;
end;
end;