Oracle PL/SQL Fundamentals

This hands-on course introduces the Oracle PL/SQL programming language. Students will learn critical aspects of PL/SQL including language basics, if statements, cursors, loops, stored program units and error handling.


    • What is PL/SQL?
    • PL/SQL block structure
    • Declaring local variables
    • Scope of local variables
    • Conditional control using the IF and CASE statements
    • Loop constructs
    • Implicit and explicit cursors
    • Cursor attributes and cursor parameters
    • Error handling
    • Stored program units
    • Procedures
    • Functions
    • Packages
    • Database Triggers

    Oracle application developers

    Oracle SQL Fundamentals or equivalent experience

    Students will be able to code PL/SQL programs that include common programming constructs such as data-typing, variable assignment, flow control, array-like processing and error handling.

    • PC Workstation for use during training
    • Student Manual

    • Oracle Advanced SQL
    • Oracle Advanced PL/SQL
    • Oracle Forms
    • Oracle Reports

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    © Euler. All rights reserved.
    Contact Us to Register