Infoschool

PL/SQL

Oracle PL/SQL Training Overview

The primary objective of this Oracle training class is to provide an introduction to the PL/SQL database programming language, based upon the latest features available in Oracle 10g.

Oracle PL/SQL Training Class Goals

Understand the environment and context in which PL/SQL operates.
Consider the advantages and benefits of PL/SQL within a database environment.
Learn to declare program variables and complex data types.
Learn to develop logic within PL/SQL program blocks.
Learn to fetch data from the database into program variables.
Learn to return program output to users.
Learn to handle program exceptions.
Learn to use explicit and implicit database cursors.
Learn to use the advanced features of nested blocks and subprograms.

Oracle PL/SQL Courseware

1.Language Features

Understanding Pl/SQL
Structure Of A Pl/SQL Program Block
Pl/SQL From Interactive Tools
Generating Output Within SQL*Plus

2.Declare Clause

About The Declare Clause
Declare Simple Types
Complex Types

3.Begin Clause

About The Begin Clause
Performing Data Manipulation
Logic Control & Branching

4.Exception Clause

About The Exception Clause
Isolating The Specific Exception

5.Explicit Cursors

About Explicit Cursors
Advanced Cursor Techniques

6.Advanced Programming: Nested Blocks

1. About The Advanced Features 2. Using Nested Blocks

7.Advanced Programming: Declared Subprograms

Email:

E-Mail:*	Enter correct e-post adress Enter e-post adress
Password:*	Enter Password
	register

Contact counselors

Training @ infoschool

Success stories

I got the opportunity of getting a practical experience on SAS couse from InfoSchool. It helped me in learning new analytical tools and their applications, today I am in my dream job. Thanks to InfoSchool for giving this opportunity.

By Vidya,
SAS Developer, PowerSoft Technologies,