Oracle 10g: Programming with PL/SQL培训
Oracle 10g: Programming with PL/SQL培训
培训大纲：
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 and invoke that procedure
Handle exceptions in stored procedures
Execute a stored procedure in which you have assigned parameter values and handled exceptions
Create and execute a stored function
Call, remove, and view stored functions in PL/SQL