Intro to Oracle 9i: PL/SQL Language

  • 1h 43m
  • Sideris Courseware Corporation
  • Sideris
  • 2004

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

All Oracle professionals including developers, database administrators, designers and analysts.

Mandatory Prerequisites

  • Introduction to Oracle 9i: SQL
  • Introduction to Oracle 9i: Advanced SQL

In this Book

  • Course Introduction
  • Workshop Section—Course Introduction
  • Language Features
  • Workshop Section—Language Features
  • DECLARE Clause
  • Workshop Section—DECLARE Clause
  • BEGIN Clause
  • Workshop Section—BEGIN Clause
  • EXCEPTION Clause
  • Workshop Section—EXCEPTION Clause
  • Explicit Cursors
  • Workshop Section—Explicit Cursors
  • Advanced Programming Features
  • Workshop Section—Advanced Programming Features
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Book Beginning Database Design Solutions: Understanding and Implementing Database Design Concepts for the Cloud and Beyond, Second Edition
Book Querying MySQL: Make your MySQL Database Analytics Accessible with SQL Operations, Data extraction, and Custom Queries
Book Pro Oracle SQL Development: Best Practices for Writing Advanced Queries, Second Edition