Oracle PL/SQL

In Birmingham, London, Bristol and 3 other venues

£ 725 + VAT

Description

  • Duration

    2 Days

Description

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

Starts

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

Starts

On request
Bristol (Avon)

Starts

On request
Edinburgh (Midlothian/Edinburghshire)

Starts

On request
Leeds (West Yorkshire)

Starts

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

Starts

On request
Manchester (Greater Manchester)

Starts

On request
See all (6)

Questions & Answers

Ask a question and other users will answer you

Who do you want to respond to your question/enquiry?

We will only publish your name and question

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