0345 4506120

Oracle 11g PL/SQL

Oracle 11g PL/SQL training course introduces the fundamentals of Oracle's procedural language, PL/SQL, the engine behind the full range of Oracle technology.

We don't currently have any courses listed for Oracle 11g PL/SQL, would you like to view all courses for Oracle?

Learning Objectives

Oracle 11g PL/SQL training course introduces the fundamentals of Oracle's procedural language, PL/SQL, the engine behind the full range of Oracle technology.

The Oracle 11g plsql training course introduces the syntactic transactional languages controls evolving to cover the full range of Oracle 11g PL/SQL programming functionality found within the Oracle 11g RDBMS.

This Oracle 11g plsql practical course is an essential foundation study course needed for all Oracle 11g RDBMS professionals to maximise their utilisation of Oracle 11g and the productive benefits that can be achieved through the essential deployment of PL/SQL functionality across the business.

Pre-Requisites

  • Oracle SQL
  • PC Fundamentals

Course Content

Training Course Contents

PL/SQL Basics

  • Introduction
  • PL/SQL Block Structure

Declaring

  • Variable Types
  • Datatypes
  • Creating Variables and Constants
  • %Type Identifiers

Basic Data Processing

  • Select ¿ Into Command

Procedural Processing

  • Simple or Infinite Loops
  • While Loops
  • For Loops
  • IF Statements
  • GOTO

Data Processing

  • Data Processing
  • Creating Explicit Cursors
  • Working with Cursors
  • Using Cursors with Loops
  • Parameterised Cursors
  • Cursor Attributes
  • Implicit Cursors
  • Cursor for Loops

Oracle Supplied Packages

  • DBMS_OUTPUT
  • DBMS_JOB
  • DBMS_PROFILER
  • DBMS_RANDOM

File IO with UTL_FILE package

  • File IO with UTL_FILE package

Dynamic SQL

  • Performing Dynamic SQL with DBMS_SQL Package
  • Native Dynamic SQL

Large Object Support

  • Large Object Principles
  • Using DBMS_LOB

Error Handling

  • Introduction to Exceptions
  • Creating Programmer Defined Exceptions
  • Exceptions
  • Redefining Oracle Exceptions
  • Raising Application Errors
  • Using Error Variables

Modularization

  • PL/SQL block structure
  • Procedures
  • Functions
  • Parameters

Stored PL/SQL code

  • User Schemas
  • Hints
  • Dependencies
  • Invoker Rights
  • Overloaded Modules
  • Local Modules
  • Shared Global Area
  • Code Wrapping

Packages

  • Creating Packages
  • Dropping Packages
  • Parameter passing by reference
  • Serially reusable packages

Web PL/SQL Development

  • Output with htp.p
  • Specific htp procedures

PL/SQL Toolkit Packages

  • owa_cookie
  • owa_image
  • owa_pattern
  • owa_util
  • utl_http

10g PLSQL Language Improvement

  • Improvements discussion
  • Regular Expressions
  • Additional floating point types
  • Nested table enhancements
  • Utility packages for compression/mail/warnings

Transactional Control

  • Commit
  • Rollback
  • Savepoint
  • Autonomous Transactions

Extending the Type System

  • PL/SQL Collections
  • Associated Arrays
  • Nested Tables
  • Bulk Binds
  • Bulk Exceptions
  • Caching Data

Database Triggers

  • Writing Database Triggers
  • Database Trigger Syntax
  • Accessing Column Values in Triggers
  • Trigger Restrictions

Database Trigger Firing Sequen

  • Disabling Triggers
  • Enabling Triggers
  • Dropping Triggers
  • Database Triggers (from 9i)

Data Dictionary Views

  • Naming Conventions
  • Package security

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Our Customers Include