Oracle 10g PL/SQL

GBdirect Ltd
London,Leeds,Birmingham,Coventry,Edinburgh,Glasgow, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

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

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

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

Suitable For
Training Oracle Analyst/Programmers
Training Oracle Technicians
Training Oracle DBA’s
Training Oracle Developers
Prerequisites
PC Fundamentals
SQL for Oracle

Outline 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
Creating Explicit Cursors
Working with Cursors
Using Cursors with Loops
Parameterised Cursors
Cursor Attributes
Implicit Cursors
Cursor for Loops
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
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 Sequence
Disabling Triggers
Enabling Triggers
Dropping Triggers
Database Triggers (from 9i)
Data Dictionary Views
Naming Conventions
Package security
Oracle Supplied Packages
DBMS_OUTPUT
DBMS_JOB
DBMS_PROFILER
DBMS_RANDOM
File IO with UTL_FILE package
Dynamic SQL
Methods
Performing Dynamic SQL with DBMS_SQL Package
Native Dynamic SQL
Large Object Support
Large Object Principles
Using DBMS_LOB
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 Improvements
Improvements discussion
Regular Expressions
Additional floating point types
Nested table enhancements
Utility packages for compression/mail/warnings
...''

Phone:0800 651 0338, +44 (0)870 200 7273

School Address:

GBdirect Ltd
Training Division
Leeds Innovation Centre
103 Clarendon Road
LEEDS
LS2 9DF
West Yorkshire
United Kingdom


Jobs & Resumes: London, Leeds, Birmingham, Coventry, Edinburgh, Glasgow
Houses & Roommates: London, Leeds, Birmingham, Coventry, Edinburgh, Glasgow

Novell Network Management: Netware 6
Networking Technologies v1.0
Foundations of Novell Networking:NetWare 6
Foundations of Novell networking: Netware 6.5
Novell Services for Linux
Upgrading to Netware 6 v1.0
ZENworks for Desktop 4
eDirectory Design & Implementation v3.0
eDirectory Fundamentals
Novell eDirectory tools and Diagnostics
Oracle 10g Performance Tuning
Oracle 10g DBA Fundamentals
Oracle 10g Back Up and Recovery
Oracle 10g Portal Mangement
Oracle 10g Portal with Java Portlets
Oracle 10g JDeveloper
Oracle Overview
Introduction to PHP Programming
PHP for Programmers

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.