Learn Bench

Introduction

• Develop efficient PL/SQL programs to access Oracle databases
• Create stored procedures and functions for maximum reuse and minimum code maintenance
• Design modular applications using packages
• Manage data retrieval for front-end applications
• Bulk bind collections to increase the speed of data movement operations
• Invoke native dynamic SQL to develop high-level abstract code

Benefits

• The Oracle PL/SQL language—a flexible procedural extension to SQL—increases productivity, performance, scalability, portability and security.
• In this course, you gain the practical knowledge to write PL/SQL programs.
• You learn to build stored procedures, design and execute modular applications, and increase the efficiency of data movement.

Who Should Attend

• Programmers and others working with PL/SQL.
• A working knowledge of SQL and PL/SQL at the level of Course 926, "Oracle Database 11g Comprehensive Introduction," or Course 593, "Oracle Database 10g Comprehensive Introduction," is assumed.