Overview/Description 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 Target Audience Database administrators, application developers, and database operators Prerequisites Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata...

Overview/Description To identify the benefits associated with records and collections, declare and initialize nested tables and VARRAYs, and create and reference an INDEX BY table and table of records Target Audience Database administrators, application developers, and database operators Prerequisites Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata Expected...