|
ORA01FND-8i-02-SG
Introduction to Oracle8i: PL/SQL Language (2 Days)
Description
The Oracle PL/SQL language provides for 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.
Audience
Target audience for this course is all Oracle professionals, such as: Application developers, Database administrators, Designers
Mandatory Prerequisites
• Introduction to Oracle8i: Advanced SQL & SQL*Plus
Suggested Next Courses
• Develop Oracle8i PL/SQL Program Units
Objectives
The objective of this course is to provide an introduction to the PL/SQL database programming language. Major subject areas to be explored are:
• 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
Course Outline
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 & BRANCHING
EXCEPTION CLAUSE • HANDLING EXCEPTIONS • SPECIAL FEATURES • SYSTEM DEFINED EXCEPTIONS • SQLCODE / SQLERRM • IMPLICIT CURSORS • USER-DEFINED EXCEPTIONS • PRAGMA EXCEPTION
EXPLICIT CURSORS
ADVANCED FEATURES
|
|
|
|
