Creating Stored Procedures and Functions
To create and execute a stored function and call, and remove and view stored functions in PL/SQL
To write dynamic SQL and use the DBMS_METADATA package
Explicit Cursors and Exception Errors
To use the FOR UPDATE and WHERE CURRENT OF clauses to lock and modify rows, process data using records and cursors, and outline how each of the PL/SQL exception types are raised and handled
Getting Started with SQL and PL/SQL New Features
To recognize the scope and capabilities of enhancements to SQL and PL/SQL, including tools such as SQL*Plus and SQL Developer, and use them to create reports and scripts, browse and manage database ...
To introduce PL/SQL and provide an introduction to identifiers and variables in PL/SQL
To manage dependencies and recompile PL/SQL units
Manipulating Large Objects in PL/SQL
To use LOBs and the DBMS_LOB package
Oracle 11i E-Business Suite: Flexfields
To create value sets and to perform the tasks to define a structure for descriptive flexfields
Oracle 11i E-Business Suite: Introduction
To identify the main features of 11i E-Business Suite, to perform key navigation tasks, to create a shared entity type, and to recognize the key business flows of 11i E-Business Suite
Oracle 11i E-Business Suite: Multi-Org
To identify characteristics and key features of Multi-Org and to identify the considerations to make when implementing Multi-Org