以下是我写的SQL脚本,在test.sql文件中declare number i;
set i:=1;
while i<9 loop
set i:=i+1;
end loop
执行后,出现如下错误
system@ALEPH18> start /exlibris/tmp/a.sql
6 /
while i<9 loop
*
ERROR at line 3:
ORA-06550: line 3, column 8:
PLS-00103: Encountered the symbol "<" when expecting one of the following:
:= . ( @ % ; not null range default character请高手指教,我的脚本错在哪里?难道在oracle的脚本中不能用loop语句?急啊, 在线等答案中......
set i:=1;
while i<9 loop
set i:=i+1;
end loop
执行后,出现如下错误
system@ALEPH18> start /exlibris/tmp/a.sql
6 /
while i<9 loop
*
ERROR at line 3:
ORA-06550: line 3, column 8:
PLS-00103: Encountered the symbol "<" when expecting one of the following:
:= . ( @ % ; not null range default character请高手指教,我的脚本错在哪里?难道在oracle的脚本中不能用loop语句?急啊, 在线等答案中......
begin
i:=1;
while i < 9 loop
i:=i+1;
end loop;
end;
你写的这个PL/SQL块不合法,1楼的很正规