Question

oracle中for循环的问题

我要做循环查询出月份不同的表的数据 放到新创建的表中...
比如
create dabing_1001 as
select * from macc.xhy_all_sum_200901

create dabing_1002 as
select * from macc.xhy_all_sum_200902
。。。。。。。。。。。。。。依次类推 以下是思路 请大家帮帮忙

declare
dabing varchar2(100);
dabing2 varchar2(100);
i number;
begin
for i in 1..8 loop
loop
dabing:='macc.xhy_all_sum_20090'||i;
dabing2:='dabing_100'+i;
create table dabing2 as
select * from dabing
end loop;
end;

Answer 1

declare
dabing varchar2(100);
dabing2 varchar2(100);
ls_sql Varchar2(4000)
i number;
begin
for i in 1..8 loop
dabing:='macc.xhy_all_sum_20090'||i;
dabing2:='dabing_100'||i;
ls_sql:='Create table '||dabing2||' As select * from '||dabing;
Execute Immediate ls_sql;
end loop;
end;

以上，希望对你有所帮助！