Oracle Database 10g: Develop PL/SQL Program Units

D17169GC21

This course is designed for developers with basic PL/SQL and SQL language skills who want to develop stored procedures, functions, packages and database triggers. Students will also learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages. Students use iSQL*Plus to develop these program units. JDeveloper is introduced as an optional tool.

Course Objectives:
Write dynamic SQL for more coding flexibilityDesign PL/SQL code for predefined data types, local subprograms, additional pragmas and standardized constants and exceptionsUse the compiler warnings infrastructureManipulate large objectsCreate triggers to solve business challengesManage dependencies between PL/SQL subprogramsSchedule PL/SQL jobs to run independentlyCreate stored procedures and functionsDesign PL/SQL packages to group and contain related constructsCreate overloaded package subprograms for more flexibilityCategorize the Oracle supplied PL/SQL packagesUse the Oracle supplied PL/SQL packages to generate screen output, file output, web output, and mail output

Download:
http://rapidshare.com/files/81143269/d17169gc21_ppt.rar

Password: www.bluelibrary.org