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

• 1. Introduction to PL/SQL
  The correct structure of a PL/SQL program block
  Use iSQL*Plus to display the output of a PL/SQL anonymous block
  Declare and initialize a variable in a given scenario
  Declare and initialize scalar data types and Boolean variables
  Use bind and substitution variables and the DEFINE command to assign values in PL/SQL code
  Match the composite and LOB data types with their associated functionality
  Pass runtime values in and out of PL/SQL code
  2. Using PL/SQL with an Oracle Server
  Write lexical units in their correct format in a PL/SQL block
  Perform data conversion in PL/SQL
  Use qualifiers to access and evaluate variables in PL/SQL blocks
  Convert and evaluate variables in PL/SQL
  Use a SELECT statement in a PL/SQL block to retrieve data from a database
  Use implicit SQL cursor attributes to determine the outcome of DML commands
  Use PL/SQL to perform database operations and use SQL cursor attributes to evaluate results
  3. Using Control Structures
  Implement a suitable conditional control statement in PL/SQL for a given scenario
  Implement simple and searched CASE expressions and statements in PL/SQL
  Situations that can cause errors when handling nulls in PL/SQL
  Implement suitable control structures in PL/SQL
  Implement a suitable loop construct in PL/SQL for a given scenario
  Characteristics of FOR and nested loops in PL/SQL
  Implement suitable loop structures in PL/SQL
  4. Using Composite Data Types
  Benefits associated with records and collections in PL/SQL
  Create and populate a user-defined record in PL/SQL
  Create a record using the %ROWTYPE attribute and use it to insert and update a row
  Create a record and use it to update a table
  Create and reference an INDEX BY table and table of records
  Declare and initialize nested tables and VARRAYs
  Create and reference a table in PL/SQL
  5. Explicit Cursors and Exception Errors
  Use explicit cursors to retrieve data
  Process data using records, cursor attributes, and cursor FOR loops
  Use parameters to make cursors reusable in a given scenario
  Use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows
  Use an explicit cursor to retrieve and update data
  Outline how each of the PL/SQL exception types are raised and handled
  Trap predefined and non-predefined exceptions in PL/SQL
  Trap user-defined exceptions and identify error codes and messages
  Use nested blocks and the RAISE_APPLICATION_ERROR procedure when handling exceptions in PL/SQL
  Handle exceptions in PL/SQL
  6. Creating Stored Procedures and Functions
  Create, remove, and view PL/SQL stored procedures
  Use IN, OUT, and IN OUT parameter modes to pass values to and from stored procedures and programs
  Outline how to view values returned by OUT parameters
  Create stored procedures with suitable parameters
  Assign values to multiple parameters in a stored procedure