This hands-on course introduces the Oracle 9i 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.
|
Class Agenda:
- 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
|
Prerequisites:
- Oracle SQL Fundamentals or equivalent experience
Audience:
- Oracle application developers
Course Benefits:
- 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.
Materials Furnished:
Recommended Follow-On Course:
- Oracle 9i Advanced SQL
- Oracle 9i Advanced PL/SQL
- Oracle Forms 9i
- Oracle Reports 9i
Course Length: Two Days
List Price: $990 |
