Audience

Trainee database administrators and application developers

Prerequisites

Familiarity with programming techniques would be an advantage

Course Aim

To explain the fundamentals of PL/SQL

Learning Objectives

Understand PL/SQL block syntax. Declare variables. Understand the scope of variables. Use SQL and PL/SQL functions. Control PL/SQL flow of execution.

Topics Covered

Using variables - Block structure - Declaring variables - Using variables Writing executable statements - Programming - Guidelines - Hands-on: Determine the scope of variables Embedded SQL - Manipulating data using PL/SQL - Controlling transactions - Cursors - Hands-on: Writing PL/SQL blocks Writing control statements - Conditional control - Iterative control - Hands-on: Writing an IF statement and a loop

| About Eno.com | Security&Privacy | Contact Us |
Copyright © 1998-2001 E&A Inc.. All rights reserved.
1-877-298-1322