oracle ´æ´¢¹ý³ÌÎÊÌâ

oracle Êý¾Ý¿âÏÂдµÄ´æ´¢¹ý³Ì

CREATE OR REPLACE  PROCEDURE "TEST" is
cursor cur1 is  select unique month from tb order by month;
begin
for p in cur1
loop
  alter table tb1 add(p.month varchar2(40));
end loop;
end;


Õâ¾äΪʲô×ÜÊDZ¨´íÄØ,´íÎóÈçÏÂ:
Line # = 6 Column # = 3 Error Text = PLS-00103: Encountered the symbol "ALTER" when expecting one of the following:    begin case declare exit for goto if loop mod null pragma    raise return select update while with <ID>    <Íâ¼Ó雙Òý號µÄ·Ö½ç ID> <連結變數> < < close current    delete fetch lock insert open rollback savepoint set sql    execute commit forall merge pipe

---

ÒýÓÃ

oracle Êý¾Ý¿âÏÂдµÄ´æ´¢¹ý³Ì

CREATE OR REPLACE  PROCEDURE "TEST" is
cursor cur1 is  select unique month from tb order by month;
begin
for p in cur1
loop
  alter table tb1 add(p.month varchar2(40));
end loop;
end;


Õâ¾äΪʲô×ÜÊDZ¨´íÄØ,´íÎóÈçÏÂ:
Line # = 6 Column # = 3 Error Text = PLS-00103: Encountered the symbol "ALTER" when expecting one of the following:    begin case declare exit for goto if loop mod null pragma  &