1、培訓過程中，如有部分內容理解不透或消化不好，可免費在以后培訓班中重聽；
        2、培訓結束后,授課老師留給學員聯系方式,保障培訓效果,免費提供課后技術支持。
        3、培訓合格學員可享受免費推薦就業機會。

• 1. Introduction
  Course Objectives and Agenda
  Human Resources (HR) Schema
  PL/SQL Development Environments
  SQL Developer
  2. Introduction to PL/SQL
  PL/SQL
  Benefits of PL/SQL Subprograms
  Types of PL/SQL blocks
  Create a Simple Anonymous Block
  Generate Output from a PL/SQL Block
  3. Declare PL/SQL Identifiers
  Types of Identifiers in a PL/SQL Subprogram
  Use Declarative Section to Define Identifiers
  Use Variables to Store Data
  Scalar Data Types
  The %TYPE Attribute
  Bind Variables
  Sequences in PL/SQL Expressions
  4. Write Executable Statements
  Basic PL/SQL Block Syntax Guidelines
  Comment the Code
  Deployment of SQL Functions in PL/SQL
  Convert Data Types
  Nested Blocks
  Operators in PL/SQL
  5. Interaction with the Oracle Server
  Invoke SELECT Statements in PL/SQL
  Retrieve Data in PL/SQL
  SQL Cursor Concept
  Avoid Errors by using Naming Conventions when using Retrieval and DML Statements
  Data Manipulation in the Server using PL/SQL
  SQL Cursor concept
  Use SQL Cursor Attributes to Obtain Feedback on DML
  Save and Discard Transactions
  6. Control Structures
  Conditional Processing using IF Statements
  Conditional Processing using CASE Statements
  Simple Loop Statement
  While Loop Statement
  For Loop Statement
  Use the Continue Statement
  7. Composite Data Types
  Use PL/SQL Records
  The %ROWTYPE Attribute
  Insert and Update with PL/SQL Records
  INDEX BY Tables
  Examine INDEX BY Table Methods
  Use INDEX BY Table of