|
|
Oracle10g PL/SQL Programming
| Duration: 3 days |
| Participants: Application Developers, Programmers, and Database Administrators responsible for the development or maintenance of application systems that access an Oracle database. |
|
Objectives:
Upon successful completion of this course you will be able to:
- Know how to code application modules in PL/SQL. - Develop and create PL/SQL stored procedures, functions, packages and database triggers. |
|
Topics:
- Overview of PL/SQL - PL/SQL Variables - Manipulating Data Using SQL*Plus - PL/SQL Block Execution - Cursor Processing - Handling Exceptions - Stored Procedures - Functions - Database Triggers - Packages |
| Overview: This course provides a comprehensive examination of PL/SQL, Oracle's procedural language extension to SQL. PL/SQL can be executed from SQL*Plus, embedded within a host language, or executed on the Server. |
| Prerequisites: Participants should have taken an Oracle SQL & SQL*Plus class or have equivalent knowledge. They should also have knowledge of a procedural language (e.g., COBOL, C). |
| Format: Lecture and discussion with hands-on Lab exercises to reinforce the topics covered. |
|
Topic Outline:
- Overview of PL/SQL PL/SQL Block Structure PL/SQL Program Constructs - PL/SQL Variables Identifiers Datatypes Variables Expressions - Manipulating Data Using SQL*Plus SQL Statements in PL/SQL Blocks Retrieving Data Manipulating Data Transaction Management - PL/SQL Block Execution Control Structures Conditional Statements Loops - Cursor Processing in PL/SQL Implicit Cursors Explicit Cursors Parameterized Cursors Cursor Variables Cursor For Loops Collections in PL/SQL BULK COLLECT Feature - Handling Exceptions Predefined Exceptions Oracle Defined Exceptions User-Defined Exceptions RAISE Statement Propagation of Exceptions - Subprograms Procedures Functions Parameter Modes RETURN Statement - PL/SQL on the Server Triggers Packages |
|
|