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

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

• 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