Declaring Variable Writing Executable Statements Writing Explicit Cursor Handling Exceptions Create Procedures Create Functions