create or replace procedure test1
is
i number (10) :=1;
begin
for i in 1..9 loop
execute immediate 'environment_day_0'||i||'
(列名 数据类型 列级约束
)';
end loop;
end test1;
oracle创建名字差不多的多张表
最新推荐文章于 2023-12-15 23:09:18 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)
create or replace procedure test1
is
i number (10) :=1;
begin
for i in 1..9 loop
execute immediate 'environment_day_0'||i||'
(列名 数据类型 列级约束
)';
end loop;
end test1;