PL/SQL for Developers
- Recommended Duration:
- 2 Days
- Version
- Oracle 10g. Course covers Oracle9i and Oracle8i, it is also suitable in shops using Oracle8 or Oracle 7 (earlier course versions available).
- Benefits
- Participants will learn to use PL/SQL to enhance the operations of their Oracle applications. Several exercises will take students from the basics of PL/SQL through fairly extensive routines complete with looping, cursors, and error handling. Oracle9i students will learn and practice using the new features of PL/SQL.
- Audience
- Application developers and designers who will use PL/SQL in their applications.
- Prerequisites
- Prior knowledge of Oracle fundamentals and basic SQL is necessary. No previous experience with PL/SQL is required.
- Major Topics
-
- Introduction to PL/SQL, syntax and fundamentals
- PL/SQL statements including Arithmetic, Looping, and Conditional Logic
- Error handling (Oracle-defined & user-defined)
- Using cursors
- PL/SQL Tables
- User Defined Records and Objects
- Procedures, Functions, and Packages
- PL/SQL Parameters
- Triggers
- Built-in Packaged Procedures
- Bulk bind
- New features of PL/SQL
- Exercises
- There are five machine exercises.