Training: Oracle Database 11g: Program with PL/SQL (exam 1Z0-144)

recognize the steps for performing basic data manipulation and transaction control in PL/SQL, and for determining the outcome of SQL statements. identify the steps for writing control structures, such as IF statements and CASE expressions, in a PL/SQL block. recognize the steps for writing and identifying loop statements. create PL/SQL blocks that incorporate loops and conditional control structures.

recognize the steps for creating user-defined PL/SQL records and records with the %ROWTYPE attribute. recognize the steps for creating an INDEX BY table and table of records, and identify the uses of nested tables and VARRAYs. define, create, and use INDEX BY tables and a PL/SQL record in a given scenario. identify the steps for declaring and controlling explicit cursors, and for writing FOR loops to fetch data from them. recognize the steps for declaring and using cursors with parameters, locking rows, and referencing the current row in an explicit cursor.

identify the steps for selectively including PL/SQL source code by using conditional compilation, and for wrapping a PL/SQL unit. recognize the steps for predicting how changing a database object affects procedures and functions by tracking procedural dependencies. recognize the steps for managing remote dependencies and recompiling a PL/SQL program unit. use conditional compilation, wrap PL/SQL code, and manage dependencies in a given scenario.