Overview/Description To recognize the steps for creating and using efficient PL/SQL packages, including Oracle-supplied packages, executing dynamic SQL, and improving the performance of code. Target Audience System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers. Prerequisites Previous programming experience and knowledge of SQL Expected Duration (hours) 2.3 Lesson ObjectivesOracle Database 11g: Packages, Dynamic SQL, and Coding Considerations recognize the steps for overloading subprograms, using forward...

Overview/Description To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions. Target Audience System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers. Prerequisites Previous programming experience and knowledge of SQL Expected Duration (hours) 2.3 Lesson ObjectivesOracle Database 11g: Subprograms, Packages, and Exception Handling identify the benefits of modularized and layered subprogram design. recognize the...

Overview/Description To recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables. Target Audience System analysts, PL/SQL developers, forms and application developers, database administrators, technical consultants, and portal developers. Prerequisites Previous programming experience and knowledge of SQL Expected Duration (hours) 2.0 Lesson ObjectivesOracle Database 11g: Using Exceptions, Subprograms, JDeveloper, and REF Cursors identify the steps for trapping non-predefined exceptions...