ORACLE/RDBMS

  • Overview

    • Why use PL/SQL?
    • PL/SQL and Oracle RDBMS
    • PL/SQL and the Oracle tools
    • PL/SQL and the object relational database

  • PL/SQL components and syntax

    • Block structure
    • Variable scope
    • Syntax and punctuation
    • Running PL/SQL code from SQL*Plus
    • Exercise I
    • Variables and program units
    • Anchoring variables
    • TYPE operator
    • PL/SQL-provided functions
    • Exercise II

  • PL/SQL control structures

    • Conditional control structures
    • Sequential control structures
    • Iterative control structures
      • The Basic Loop
      • The Numeric FOR Loop
      • The WHILE Loop
      • The Cursor FOR Loop
    • Exercise III
    • Exercise IV

  • PL/SQL cursors

    • Overview
    • Implicit cursors
    • Explicit cursors
    • Exercise V
    • Cursor attributes
    • Exercise VI
    • The Cursor FOR Loop
    • Exercise VII
    • Tips and techniques
    • Exercise VIII
    • SELECT FOR UPDATE clause

  • PL/SQL exception handling

    • Exception overview
    • Exception types
    • Tips and techniques
    • Exercise X

  • PL/SQL stored program units

    • Overview
    • Procedures and functions
    • Creating and maintaining program units
    • Running stored program units
    • Exercise XI
    • Exercise XII
    • Packages
    • Stored program units and the Oracle data dictionary
    • Exercise XIII
    • Exercise XIV

  • PL/SQL built-in packages

    • Overview
    • DBMS_JOB
    • DBMS_SQL
    • DBMS_PIPE
    • UTL_FILE

  • Database triggers

    • Overview
    • Creating triggers
    • Managing triggers

  • 10g new features

    • Overview

  • Miscellaneous tips and techniques

    • Coding standards
    • Source code control
    • Debugging tips
  • Review

  • For more information

  • Bibliography

News And Events

At SAPPHIRE '07 Atlanta -- scheduled for April 22 to 25 in the Georgia World Congress Center, Atlanta, Georgia -- you'll discover how today's open technologies can transform your business processes, shorten the path between a great idea and a great product, and energize your value chain. Plus, you'll learn how SAP's strategy for co-innovation with a growing ecosystem of partners will give you more solution options than ever before.

OpenWorld Latin America
March 27-29, 2007
TransAmerica Expo
Sao Paulo Brazil

OpenWorld APAC
July 30-August 2, 2007
Shanghai, China

OpenWorld San Francisco
November 11-15, 2007
Moscone Center
San Francisco
Copyrights 2007@opusinfoserve.com