UC知道oracle中for循环的问题
来源：百度知道 编辑：UC知道 时间：2024/05/28 12:34:38
我要做循环查询出月份不同的表的数据 放到新创建的表中...
比如
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;
比如
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;
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;
以上，希望对你有所帮助！