loop

SQL/PL

Loop statement

Syntax

loop_stmt:
          [ label_name:] LOOP statement_list END  LOOP [ label_name]

Description

The LOOP statement will repeatedly execute statement_list until a LEAVE (or RETURN in a function) statement is executed. If an END LOOP specifies label_name then an identical opening label_name: must be specified as well.

Example

find_author: loop    fetch authors into author_row;    if end_of_search = true then        leave find_author;    end if;    if author_row.yr_born between decade and decade + 9 then        set numfound = numfound + 1;        select numfound, author_row.full_name, author_row.yr_born;    end if;end loop;