LOOP
update (select d.id as did, d.next as dnext, d.message as dmessage, s.id as sid, s.next as snext, s.message as smessage from destination d, dbmsglin s where d.next= s.id) set did=sid,dnext=snext, dmessage=dmessage||smessage
EXIT WHEN SQL%NOTFOUND
END LOOP报这个错误: SP2-0734: unknown command beginning "LOOP updat..." - rest of line ignored.
update (select d.id as did, d.next as dnext, d.message as dmessage, s.id as sid, s.next as snext, s.message as smessage from destination d, dbmsglin s where d.next= s.id) set did=sid,dnext=snext, dmessage=dmessage||smessage
EXIT WHEN SQL%NOTFOUND
END LOOP报这个错误: SP2-0734: unknown command beginning "LOOP updat..." - rest of line ignored.
好像循环都不是这么写的吧
SQL> set serveroutput on
SQL>
SQL> declare
2 i number;
3 BEGIN
4 i:=0.0;
5 loop
6 UPDATE (SELECT * FROM test0302) SET testcol='xxx' WHERE 1<>1;
7 COMMIT;
8 i:=i+1;
9 dbms_output.put_line(to_char(i));
10 exit when i=1.0;
11 end loop;
12 end;
13 /1PL/SQL procedure successfully completedSQL> edit
SQL> edit
SQL>
SQL> declare
2 i number;
3 BEGIN
4 i:=0.0;
5 loop
6 UPDATE (SELECT * FROM test0302) SET testcol='xxx' WHERE 1<>1;
7 COMMIT;
8 i:=i+1;
9 dbms_output.put_line(to_char(i));
10 exit when i=3.0;
11 end loop;
12 end;
13 /1
2
3PL/SQL procedure successfully completedSQL>