Oracle Database 10g: PL/SQL Fundamentals (Self-Study Course)
Who should attend
- Database designers
- Forms developers
- Technical consultants
- PL/SQL developers
Course Objectives
- Create, execute, and maintain procedures, functions, packages, and triggers
- Manage dependencies
- Manipulate large objects
- Conditionally control code flow (loops, control structures, and explicit cursors)
- Handle runtime errors
- Manage program constructs
- Describe the features and syntax of PL/SQL
Product Description
- Programming with PL/SQL
- Identify features of PL/SQL
- Identify benefits of PL/SQL
- Identify features of PL/SQL blocks
- Match different PL/SQL program constructs with their features
- Identify features of the iSQL* Plus programming environment
- Identify features of PL/SQL variables
- Identify guidelines for declaring PL/SQL variables
- Identify features of various PL/SQL data types
- PL/SQL Blocks
- Identify features of PL/SQL blocks within a subprogram
- Match types of PL/SQL named blocks with their descriptions
- Match types of PL/SQL environments with their descriptions
- Identify the syntax for creating a stored procedure
- Identify features of the parameters used in stored procedures
- Identify the syntax for passing parameters to a stored procedure
- Identify tasks involved in using stored procedures
- Identify the syntax for creating a PL/SQL function
- PL/SQL Packages
- Identify features of PL/SQL packages
- Sequence steps for developing PL/SQL packages
- Identify the syntax for creating a PL/SQL package
- Identify tasks involved in managing PL/SQL packages
- Identify features of the overloaded subprograms contained in PL/SQL packages
- Identify features of forward referencing in PL/SQL packages
- Identify features of the PL/SQL package state
- Identify features of the PL/SQL wrapper utility
- Triggers
- Identify features of triggers
- Identify the code to create a Data Manipulation Language (DML) trigger
- Identify the code to create a Data Manipulation Language (DML) row trigger
- Identify the code to create an INSTEAD OF trigger
- Match the options for managing triggers with their descriptions
- Identify guidelines for testing triggers
- Identify the benefits of triggers in different business application scenarios
- Identify the syntax for creating triggers for DDL and system events
- Dynamic SQL Statements
- Match the stages in the execution of SQL statements with their descriptions
- Identify features of dynamic SQL
- Identify the features of the DBMS_SQL package
- Identify features of the subprograms in the DBMS_METADATA package
- Identify the features of Large Objects (LOBs)
- Identify features of internal Large Objects (LOBs)
- Identify features of Binary Files (BFILEs)
- Identify tasks involved in managing Binary Files (BFILEs)
- Large Object (LOB) data type
- Identify features of the DBMS_LOB package
- Identify the code to work with Large Object (LOB) values
- Identify methods of selecting Character Large Object (CLOB) values
- Identify features of temporary Large Objects (LOBs)
- PL/SQL Design Considerations
- Identify guidelines for standardizing constants and exceptions
- Identify benefits of using local subprograms
- Sort the characteristics of the rights models according to their category
- Identify features of autonomous transactions
- Identify features of bulk binding
- Identify features of dependencies
- Identify tasks you need to perform for displaying dependencies
- Identify features of local dependencies. Identify features of remote dependencies
- Compilation Tools and Options
- Identify features of native compilation
- Identify settings to be specified for native compilation
- Sequence the steps to enable native compilation of PL/SQL code
- Identify features of compiler warnings
- Identify features of the PLSQL_WARNINGS parameter
- Identify features of the DBMS_WARNINGS package
- Identify features of the NOCOPY and PARALLEL_ENABLE hints