4.1.10. Execution

  • BEGIN (not in order)
    • /* sql_statements */
      • UPDATE employee SET salary = salary+1;
    • /* conditionals */
      • IF (age < 0) THEN
        • age: = 0;
      • ELSE
        • age: = age + 1;
      • END IF;
    • /* transaction processing */
      • COMMIT; ROLLBACK;
    • /* loops */ /* cursors */
  • [END;] (if no exception handling)