Introduction to Oracle8i: PL/SQL Language

This 2-day course provides an introduction to Oracle PL/SQL programming logic features not contained within SQL. The grammar, syntax and benefits of using the PL/SQL language within an Oracle database environment are considered. On course completion, students will have explored:

• Declaring variables and complex datatypes
• Developing logic within PL/SQL program blocks
• Fetching data from the database into program variables
• Returning program output to users
• Handling program exceptions
• Using explicit and implicit database cursors
• Using the advanced features of nested blocks and subprograms

Target audience

This course has been developed for all Oracle professionals such as Application Developers, Database Administrators and Designers. Students are recommended to have attended the following course or have the equivalent knowledge and experience:

• Introduction to Oracle8i: Advanced SQL & SQL*Plus

Course content

Language features Understanding PL/SQL • Structure of a PL/SQL program block • Generating output

DECLARE clause Datatypes • Declaration features • Special datatypes • %ROWTYPE record • TYPE ... TABLE • TYPE ... RECORD

BEGIN clause Data manipulation • CHAR and VARCHAR2 • Database access • Logic control and branching

EXCEPTION clause Handling exceptions • Special features • System defined exceptions • SQLCODE / SQLERRM • Implicit cursors • User-defined exceptions • PRAGMA exception

Explicit cursors

Advanced features

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today