Oracle PL/SQL
Course
In London, Birmingham, Bristol 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.
Facilities
Location
Start date
Start date
Start date
Start date
Start date
Start date
Start date
Reviews
Course programme
- 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