一个动态创建表的问题~

[kingzhang]

TableName := 'n01_SH_sp'+Str_locIP ;
Str_Cre := 'Create Table '+TableName+' As '+
'select n0100,n0101,a2102,n0103,n0102,c0103,c0104,n0104,n0105,a2118 from n01,a21,c01 '+
'where n0101>=:rq1 and n0101<=:rq2 and c0101=n0102 and a2118=n0100 ';
请问应该怎么做~谢谢~

[kingzhang]

急,在线等~

[mantisXF]

TableName := 'n01_SH_sp'||Str_locIP ;
Str_Cre := 'Create Table '||TableName||' As '||'select n0100,n0101,a2102,n0103,n0102,c0103,c0104,n0104,n0105,a2118 from n01,a21,c01 '||'where n0101>=:rq1 and n0101<=:rq2 and c0101=n0102 and a2118=n0100 ';
execute immediate Str_Cre;

[oraclelogan]

[Quote=引用 2 楼 mantisXF 的回复:]
TableName   :=   'n01_SH_sp '||Str_locIP   ;
Str_Cre   :=   'Create   Table   '||TableName|| '   As   '|| 'select   n0100,n0101,a2102,n0103,n0102,c0103,c0104,n0104,n0105,a2118   from   n01,a21,c01   '|| 'where   n0101> =:rq1   and   n0101 <=:rq2   and   c0101=n0102   and   a2118=n0100   ';
execute   immediate   Str_Cre;
[/Quote]

学习啦，不错。