spool c:\a.txt select * from tablename; spool off;
用spool 太慢了吧,这几百万行的,恐怕有点不现实。
for num in 1..9 loop execute immediate 'create table :1 as select tel,decode(.........) col1 ..... from :2' using 'aa_'||num,'bb_'||num; end loop; 这个能不能介绍详细点 那个1,2指的是什么,我运行了,提示:无效的sql语句
execute immediate 'create table :1 as select tel,decode(.........) col1 ..... from :2'
using 'aa_'||num,'bb_'||num;
end loop;
select * from tablename;
spool off;
execute immediate 'create table :1 as select tel,decode(.........) col1 ..... from :2'
using 'aa_'||num,'bb_'||num;
end loop;
这个能不能介绍详细点 那个1,2指的是什么,我运行了,提示:无效的sql语句