| IF expression THEN
statement; ... [ELSIF exception THEN statement; ...] ... [ELSE statement; ...] END IF; |
| [<<label>>]
LOOP [EXIT;] [EXIT WHEN condition;] statement; ... END LOOP [<<label>>]; |
| [<<label>>]
WHILE condition LOOP statement; ... END LOOP [<<label>>]; |
| [<<label>>]
FOR counter IN [REVERSE] start_val .. end_val LOOP statement; ... END LOOP [<<label>>]; |
| FOR { var_list | record }
IN { cursor_name | (select_statement) } LOOP statement; ... END LOOP; |
| <<label>>
GOTO label; |
作为占位符，不执行任何操作。
| NULL; |
| 关键词 | 描述 |
|---|---|
| TYPE | 类型定义关键词 |
| type_name | 记录类型名 |
| record_name | 记录变量名 |
| var_name | 记录内的变量名 |
| table_name | 数据库中的表名 |