On-site & Public, Instructor-led, Hands-on IT Training
800.756.3000
(International 01) 908.233.8900
  400+ Course Offerings:


Search for Course:

OR5460 Introduction to Oracle PL/SQL Programming
 
 
Duration 3 Days
Delivery Method Instructor Led, Hands-on workshops
Public Price $1625.00


DESCRIPTION (Return to Top)

The course provides a comprehensive introduction to PL/SQL, Oracle’s procedural language extension to SQL. PL/SQL is used to write stored procedures, packages, and database triggers. PL/SQL will be of particular interest to individuals developing applications in a client-server or multi-tier environment.

This course can be taught for any Oracle version.



AUDIENCE (Return to Top)

Programmers and Database Administrators responsible for the development or maintenance of application systems which access an Oracle database.



TOPICS (Return to Top)
  • Overview of PL/SQL
  • Variables and Constants
  • PL/SQL Executable Statements
  • Embedding SQL Within PL/SQL
  • PL/SQL in the SQL*Plus Environment
  • Handling Exceptions
  • PL/SQL Built-in Functions
  • Subprograms
  • PL/SQL on the Server
  • Using Predefined Packages


PREREQUISITES (Return to Top)

OR5450 Oracle SQL or equivalent experience.