Oracle 10g PL/SQL

In Oracle 10g SQL Programming training, students write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle. They learn programming, management, and security issues of working with PL/SQL program units. Programming topics will include the built-in packages that come with Oracle®, the creation of triggers, and stored procedure features.

Why Oracle in Mazenet

  • Mazenet is the authorized Oracle corporation to deliver Oracle product.
  • Mazenet is the Oracle WDP(Workforce development Program) so we provide Oracle E-kit.
  • Mazenet offers 25% discount vouchers on any oracle globally certified examinations.
  • Mazenet provide the Oracle Course Completion certificate only and no mazenet certifications.
  • Mazenet deliver the syllabus mapped by the Oracle Corporation.
  • Mazenet offers the value added informations about Oracle 11g features after completing Oracle 10g DBA.
  • Mazenet provides Oracle 11g tool kits to deliver the program.
  • Mazenet delivers the examinations directly through the Oracle Corporation.


PL/SQL, then, is an application-development language that is a superset of SQL, supplementing it with standard programming-language features that include the following:

  • block (modular) structure
  • flow-control statements and loops
  • variables, constants, and types
  • structured data
  • customized error handling

Unlike SQL, PL/SQL is not an industry standard, but is an exclusive product of Oracle Corporation.

Oracle 10g PL/SQL Training Objectives

All attendees will learn how to:

  • Understand the environment and context in which PL/SQL operates.
  • Consider the advantages and benefits of PL/SQL within a database environment.
  • Declaring program variables and complex data types.
  • Developing logic within PL/SQL program blocks.
  • Fetching data from the database into program variables.
  • Returning program output to users.
  • Handling program exceptions.
  • Using explicit and implicit database cursors.
  • Using the advanced features of nested blocks and subprograms.
  • How to take advantage of new features such as regular expression support and the handling of string literals within program code.

Oracle 10g PL/SQL Training Outline

  • Introduction to PL/SQL
  • Declare PL/SQL Identifiers
  • Write Executable Statements
  • Interaction with the Oracle Server
  • Control Structures
  • Composite Data Types
  • Explicit Cursors
  • Exception Handling
  • Stored Procedures
  • Stored Functions and Debugging Subprograms
  • Packages
  • Deploying Packages
  • Implement Oracle-Supplied Packages in Application Development
  • Dynamic SQL
  • Design Considerations for PL/SQL Code
  • Triggers
  • Creating Compound, DDL, and Event Database Trigger
  • PL/SQL Compiler
  • Manage Dependencies

Exit Profile

Learner will be able to design PL/SQL program units to interface with the database

Global Certification Mapped

(Before you have to complete 1Z0-047)
Exam Number: 1Z0-047
Associated Certifications: PLSQL Developer OCA