PLSP10g - ORACLE 10g: Creating Program Units Using PL/SQL

This course introduces you to PL/SQL and helps you understand the benefits of this powerful programming language. In the class, you learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. You use iSQL*Plus to develop these program units, learn to manage PL/SQL program units and database triggers, to manage dependencies, to manipulate large objects, handle exceptions and to use some of the Oracle-supplied package.

Who the course is for

Analytics – designers

Developers

Technical Consultant

What we teach you

Create, execute, and maintain procedures, functions, packages and database triggers
Manipulate large objects (LOB)
Describe Oracle supplied packages
Provide an overview of PL/SQL basics
Handling Exceptions
Manage PL/SQL program constructs
Describe the PL/SQL development environments

Required skills

Knowledge covered in course Introduction to Oracle9i: SQL (SQL9i)

Knowledge covered in course ORACLE 9i: PL/SQL Fundamentals(PLSF)

Teaching methods

Expert instruction with practical examples, computer practice

Teaching materials

The student materials include comprehensive courseware and other necessary materials for this class. All reading materials are in English.

Course syllabus

Overview of PL/SQL

Distinguishing between anonymous PL/SQL blocks and PL/SQL subprograms
Describing the PL/SQL development environments

Working with Procedure Builder

Describe the features of Procedure Builder
Manage program units using the Object Navigator
Create and compile program units using the Program Unit Editor
Invoke program units using the PL/SQL interpreter

Creating Procedures

Describe the usese of procedures
Create client–side and server–side procedures
Create procedures with arguments
Invoke a procedure
Remove a procedure

Creating Functions

Describe the uses of functions
Create client–side and server–side functions
Invoke a function
Remove a fnction
Differentiate between a procedure and a function

Creating Packages

Describe packages and list their possible components
Create a package to group together related variables, cursors, constructs, exceptions, procedures and functions
Make a package construct either public or private
Invoke a package construct
Write packages that make use of the overloading feature of PL/SQL
Avoid errors with mutually referential subprograms
Initialize public or private variables with an automatic one time only procedure
Declare ref cursors in a package

Creating Database Triggers

Describe database triggers and their use
Create database triggers
Describe database trigger firing rules
Drop database triggers
Additional Package Concepts

Managing Subprograms

Describe system privilege requirements
Track procedural dependencies
Predict the effect of changing a database object upon stored procedures and functions
Describe object dependencies
Debug client–side and server–side subprograms

Managing Dependencies

Recommended prior courses

OFUN - Úvod do databází a jazyka SQL v prostředí Oracle
PLSF10g - ORACLE 10g: PL/SQL Fundamentals
SQL10g - Oracle 10g: SQL Language

Recommended subsequent courses

SQL_TUN10g - Oracle 10g: SQL Tuning
10g_DBAI - Oracle Database 10g: Administration Workshop I
XML_FUND - Oracle 10g: XML Fundamentals
XML_PLS - Oracle Database 10g: Use XML for SQL and PL/SQL developers
FM10g - Oracle Forms Developer 10g: Build Internet Applications
APEX - Oracle Application Express 3.0: Developing Web Applications

Catalog price of course and handbook

Locality Course length Course price ex VAT Price of handbook ex VAT Number IT points

Praha 3 31500 Kč -- 60 items

Brno 3 31500 Kč -- 60 items

Course dates

No dates have been announced yet. If you are seriously interested, please contact our customer service department for more information about the option of arranging special course times on tel. +420 234 064 900-3 (Prague), +420 542 219 935-6 (Brno).