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
Please Login or Register (Quick) to see the download links.