较为复杂的sql
时间：2021-07-01 10:21:17
帮助过：1人阅读
i number :
= 1;
begin
loop
if (i
< 10)
then
execute immediate
‘alter table wt_cell_l_3 add(NS00‘ || i
||
‘ varchar(20))‘;
else
if (i
>= 10 and i
<= 99)
then
execute immediate
‘alter table wt_cell_l_3 add(NS0‘ || i
||
‘ varchar(20))‘;
else
execute immediate
‘alter table wt_cell_l_3 add(NS‘ || i
||
‘ varchar(20))‘;
end if;
end if;
i := i
+ 1;
exit when(i
> 100);
end loop;
end;
较为复杂的sql
标签：
