Oracle PL/SQL

Course

In London, Birmingham, Bristol and 3 other venues

£ 725 + VAT

Description

  • Duration

    2 Days

By the end of the course, the delegate will be able to write programs which use some or all of the primary PL/SQL programming constructs.Together with the PL/SQL Stored Program Units course, this course is suitable for delegates intending to sit the Oracle examination #1Z0-147: Program with PL/SQL.

Facilities

Location

Start date

Birmingham (West Midlands)
Spring House, 3010 The Crescent, Solihull Parkway, Birmingham Business Park Birmingham, B37 7YE

Start date

On request
Bristol (Avon)

Start date

On request
Edinburgh (Midlothian/Edinburghshire)

Start date

On request
Leeds (West Yorkshire)

Start date

On request
London
See map
3-5 Crutched Friars, EC3N 2HR

Start date

On request
Manchester (Greater Manchester)

Start date

On request
See all (6)

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Course content
  • Program Blocks
  • Variables and Constants
  • Data Types * UsingSQLStatements within PL/SQL Programs
  • GeneratingSQL*Plus andSQLDeveloper Output
  • IFTHENELSIFELSEStatements
  • CASEExpressions
  • Basic Loops
  • TheWHILEandFORLoops
  • Nested and Labelled Loops
  • Using Cursors
  • Parameterised Cursors
  • Handling Named and UnNamed Exceptions
  • Generating User Defined Exceptions
  • Nested and Labelled Block Structures
  • Scope of Variables
  • PL/SQL Records
  • PL/SQL Tables of Records
  • Handling PL/SQL Tables

Oracle PL/SQL

£ 725 + VAT