Oracle PL/SQL Course OverviewEnglish - Please note this course is only available in English. Nederlands - Let op: deze training is alleen in het Engels beschikbaar. Français - Veuillez noter que ce cours est uniquement disponible en anglais. The Oracle PL/SQL course is designed to introduce Oracle DBAs,software development personnel and database support staff to the primary features and con Oracle PL/SQL Training Course Course Contents - DAY 1 Course Introduction Administration and Course Materials Course Structure and Agenda Delegate and Trainer Introductions Session 1: 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 Session 2: PROGRAM LOGIC IF THEN ELSIF ELSE Statements CASE Statements The Basic Loop Construct WHILE and FOR Loops Nested and Labelled Loops The GOTO Statement The CONTINUE Statement Session 3: USING CURSORS What is a Cursor? Implicit and Explicit Cursors Cursor Operations Declaring,Opening and Closing Cursors Fetching Rows Status Checking Using Cursors
