较为复杂的sql
标签：
较为复杂的sql
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;