4.1.08. PL/SQL

  • Blocks broken into three parts
    • Declaration
      • Variables declared and initialised
    • Execution
      • Variables manipulated/actioned
    • Exception
      • Error raised and handled during exec

  • DECLARE
        ---declarations
    BEGIN
        ---statements
    EXCEPTION
        ---handlers
    END ;