| Oracle PL/SQL Programming |
| |
| 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. |
|
| Covered Topics: |
- 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
|
|
|
|
|
|
