Oracle PL/SQL

Course

In Bristol, Manchester, Birmingham and 3 other venues

£ 795 + VAT

Description

  • Type

    Course

This course is designed to introduce Oracle DBAs, software development personnel and database support staff to the primary features and constructs of the PL/SQL Programming Language.

Facilities

Location

Start date

Birmingham (West Midlands)

Start date

On request
Bristol (Avon)

Start date

On request
Edinburgh (Midlothian/Edinburghshire)

Start date

On request
Leeds (North Yorkshire)

Start date

On request
London
See map
Clerks Court 18-20 Farringdon Lane Clerkenwell, EC1R 3AU

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

Subjects

  • PL/SQL
  • SQL
  • IT

Course programme

PL/SQL Fundamentals

  • What is PL/SQL?
  • Basic Elements
  • Variables and Constants
  • Data Types
  • Initialising Variables and Assigning Values
  • Using SQL Statements in Code
  • Generating Output to SQL or SQL Developer

Program Logic

  • IF THEN ELSIF ELSE Statements
  • CASE Statements
  • The Basic Loop Construct
  • WHILE and FOR Loops
  • Nested and Labeled Loops
  • The GOTO Statement
  • The CONTINUE Statement

Using Cursors

  • What is a Cursor?
  • Implicit and Explicit Cursors
  • Cursor Operations
  • Declaring, Opening and Closing Cursors
  • Fetching Rows
  • Status Checking
  • Using Cursors FOR UPDATE
  • The Cursor FOR Loop
  • Parameterised Cursors

Exceptions and Nested Blocks

  • The EXCEPTION Section
  • Types of Exception
  • Handling Named System-Raised Exceptions
  • Handling Un-named System-Raised Exceptions
  • User-Declared Exceptions and Application Errors
  • WHEN OTHERS THEN NULL
  • Nested and Labelled Blocks
  • Propagation of Exceptions
  • Scope of Variables and Cursors
  • Scope of Goto Statements

PL/SQL Records and Index-By Tables

  • Declaring Record Types
  • Handling PL/SQL Records
  • Nested Records
  • Declaring PL/SQL Index-By Tables or Associative Arrays
  • PL/SQL Table Built-in Functions
  • Manipulating PL/SQL Tables or Associative Arrays

Oracle PL/SQL

£ 795 + VAT