写oracle function 时，怎样跳出loop?

Question

相当于java中的break的作用

Answer 1

Loop              If emps%found then                     Dbms_output.put_line(‘...');                     Fetch emps into emp;                     Row := row + 1;              Elsif emps%notfound then                     Exit;  ---exit loop, not IF              End if;       End loop;