ORACLE: PL/SQL Programming - Advanced Performance Objectives

ORACLE: PL/SQL Programming - Advanced Performance Objectives SYS-ED/COMPUTER EDUCATION TECHNIQUES, INC. (Oracle: PL/SQL Advanced - 3.7) Perf Obj: Page 1 Chapter 1: Control Structures You will learn: • Uses and types of control structures. • Constructing an IF statement. • CASE expressions. • Constructing and identifying different loop statements. • Logic tables. • Controlling block flow using nested loops and labels. Chapter 2: Composite Data Types You will learn: • User-defined PL/SQL records. • Creating a record with the %ROWTYPE

attribute. • Creating a INDEX BY table. • Creating INDEX BY table of records. • Difference between records, tables, and tables of records. Chapter 3: Explicit Cursors You will learn: • Differences between an implicit and an explicit cursor. • When and why to use an explicit cursor. • Use of a PL/SQL record variable. • Writing a cursor FOR loop. • Writing a cursor that uses parameters. • Use of FOR UPDATE clause in a cursor. • Use of the HERE CURRENT OF clause. • Writing a cursor that uses a subquery. • File name transformations. ORACLE: PL/SQL Programming - Advanced Performance Objectives SYS-ED/COMPUTER EDUCATION TECHNIQUES, INC. (Oracle: PL/SQL Advanced - 3.7) Perf Obj: Page 2 Chapter 4: Programming Style • Effective coding styles. • Effective layout. • Formatting single statements. • Formatting declarations. • Formatting multi-line statements. • Formatting SQL statements. • Formatting control structures. • Formatting exception handlers. • Formatting PL/SQL blocks. • Formatting packages. • Using comments. • Documenting the entire package. Chapter 5: Case Expressions You will learn: • CASE statements in PL/SQL programs. • CASE expressions. • Searched CASE expression. Chapter 6: Oracle Objects You will learn: • Abstraction. • Object types. • Overloading....

Website: www.sysed.com | Filesize: 49kb
No of Page(s): 5
Download ORACLE: PL/SQL Programming - Advanced Performance Objectives.pdf