Oracle PL/SQLCourses > Technical IT Training > Oracle > Oracle PL/SQL

  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Declaration of views_handler_argument::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_argument.inc on line 917.
  • strict warning: Declaration of views_handler_argument::query() should be compatible with views_handler::query($group_by = false) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_argument.inc on line 917.
  • strict warning: Declaration of views_handler_sort::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_sort.inc on line 165.
  • strict warning: Declaration of views_handler_sort::options_submit() should be compatible with views_handler::options_submit($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_sort.inc on line 165.
  • strict warning: Declaration of views_handler_sort::query() should be compatible with views_handler::query($group_by = false) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_sort.inc on line 165.
  • strict warning: Declaration of views_handler_filter::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_filter.inc on line 587.
  • strict warning: Declaration of views_handler_filter::query() should be compatible with views_handler::query($group_by = false) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_filter.inc on line 587.
  • strict warning: Declaration of views_handler_filter_node_status::operator_form() should be compatible with views_handler_filter::operator_form(&$form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/modules/node/views_handler_filter_node_status.inc on line 13.
  • strict warning: Declaration of views_plugin_argument_validate::options_submit() should be compatible with views_plugin::options_submit($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/plugins/views_plugin_argument_validate.inc on line 87.
  • strict warning: Declaration of views_plugin_argument_validate_taxonomy_term::options_submit() should be compatible with views_plugin_argument_validate::options_submit(&$form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/modules/taxonomy/views_plugin_argument_validate_taxonomy_term.inc on line 165.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
  • warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.
Duration: 
2 days - £795
Course ID: 
n/a

The Oracle PL/SQL 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.

Oracle PL/SQL
 
 
Duration
 
2 days
 
 
Course Overview
 
The Oracle PL/SQL 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.
 
 
Course Objectives
 
To provide the skills needed to write stand-alone programs using the main features of Oracle's PL/SQL Programming Language.

The delegates will practise:
•   Writing and running PL/SQL programs from SQL*Plus or SQL Developer
•   Declaring and using variables and constants
•   Assigning and manipulating values
•   Using SQL statements within PL/SQL
•   Implementing conditional execution and loop constructs
•   Declaring and using cursors with and without parameters
•   Updating data with cursors
•   Trapping and handling errors and exceptions in code
•   Implementing nested and labelled loops and blocks
•   Raising exceptions
•   Handling PL/SQL records and tables
•   Using PL/SQL table built-in functions
 
 
Target Audience
 
Oracle database administrators, software development personnel and database support staff who need to write PL/SQL scripts to enhance their productivity in manipulating data.
 
 
Prerequisites
 
A working knowledge of SQL*Plus or SQL Developer and Oracle SQL is required along with practical experience in writing SQL statements. This can be obtained by attendance on the pre-requisite course. Some previous programming experience will also prove advantageous.
 
 
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 FOR UPDATE
•   The Cursor FOR Loop
•   Parameterised Cursors

 
DAY 2

Session 4: 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

Session 5: 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

Please call 0141 221 5676 for course information and available dates or email us at info@indiciatraining.com.

Please contact us and we will be happy to offer further assistance.