Oracle PL/SQL
Course
In London, Manchester, Birmingham and 3 other venues
Description
-
Type
Course
-
Location
-
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. Suitable for: 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
Start date
Start date
Start date
Start date
Start date
Start date
About this course
A working knowledge of Oracle's SQL*Plus or SQL Developer products and practical experience in writing SQL statements. This can be gained by attendance on the Pre-Requisite course. Some previous programming experience will also prove advantageous.
Reviews
Subjects
- PL/SQL
Course programme
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.
Objectives:
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 theOracle examination #1Z0-147: Program with PL/SQL.
Note:
Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience.
Topics Covered:
- Program Blocks
- Variables and Constants
- Data Types
- Using SQL Statements within PL/SQL Programs
- Generating SQL*Plus and SQL Developer Output
- IF THEN ELSIF ELSE Statements
- CASE Expressions
- Basic Loops
- The WHILE and FOR Loops
- 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
A working knowledge of Oracle's SQL*Plus or SQL Developer products and practical experience in writing SQL statements. This can be gained by attendance on the Pre-Requisite course. Some previous programming experience will also prove advantageous.
Oracle PL/SQL