This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.
Students learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions. They learn about declaring variables, trapping exceptions and they also learn to declare and control cursors.
Learn To:
Declaring PL/SQL Variables
Working with Composite Data Types
Creating the Executable Section
Using Explicit Cursors
Writing Control Structures
Including Exception Handling
Please Login or Register (Quick) to see the download links.