欧美色欧美亚洲另类七区,惠美惠精品网,五月婷婷一区,国产亚洲午夜

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

• 1. Introduction to PL/SQL
  History of PL/SQL
  Features and Benefits of PL/SQL
  Relationship of PL/SQL to SQL
  PL/SQL Development Tools
  Native Compilation
  2. PL/SQL Basics
  PL/SQL Anonymous Block Structure, Lexical Units, Variable Declarations, Types, and Records
  SQL*Plus Development Environment
  Displaying Messages with DBMS_OUTPUT
  Object Naming Rules
  PL/SQL Style Guide and Coding Conventions
  3. Working with Database Data
  SELECTing Single Rows
  Declaring Variable Datatypes Dynamically
  Modifying Database Data (DML)
  Transaction Control Statements
  4. Selecting Multiple Rows Using Cursors
  Declaring Explicit Cursors
  Implicit Cursor Attributes
  Using the Cursor FOR LOOP
  5. Exception Handling
  Writing an Exception Handler Section
  Handling Predefined Exceptions
  Controlling Exception Processing - Exception Propagation
  RAISE_APPLICATON_ERROR Use
  Preventing Unhandled Exceptions
  Exception Propagation
  Using PRAGMA EXCEPTION_INIT
  6. Advanced Cursors
  Cursor Parameters
  Taking Advantage of a Weak Cursor Variable
  OPEN FOR, FETCH, and CLOSE
  Using the FOR UPDATE Clause
  Using PL/SQL Collections and Nested Collections
  7. Introduction to Procedures and Functions
  Creating Stored PL/SQL Objects, Procedures, Functions
  8. Creating Packages
  Creating Package Specifications and Bodies
  One Time Only Procedures
  Persistent State
  9. Creating DML Triggers
  Triggering Events
  Trigger Behavior
  Correlation Identifiers
  Multi-Statement Triggers
  Trigger Firing Behavior
  Enabling/Disabling Triggers
  10. Advanced Packages
  Initializing Variables
  Module Overloading
  Recursion
  Purity Levels
  11. Advanced Triggers