Oracle University |Contact: +31 (0)30 669 9244 Oracle Database 10g: Develop PL/SQL Program Units - LVC Duration: 3 Dagen What you will learn This course is designed for developers … … with basic PL/SQL and SQL language skills. In class students learn to develop, execute, and manage PL\SQL stored program units like procedures, functions, packages, and database triggers. Student also learn to manage object dependencies and recompilation of invalid objects. This course also describes the characteristics and ways of …

This course is designed for developers with basic PL/SQL and SQL language skills. In class students learn to develop, execute, and manage PL\SQL stored program units like procedures, functions, packages, and database triggers. Student also learn to manage object dependencies and recompilation of invalid objects. This course also describes the characteristics and ways of manipulation of large objects. Students are introduced to the utilization of some of the Oracle-supplied packages.This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification. Learn To:Create and manage Procedures and FunctionsManage Dependencies and Large ObjectsCreate Packages and maintain themCreate and apply TriggersUtilize Oracle-Supplied Packages in Application DevelopmentUnderstand and influence the PL/SQL Compiler A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made. Audience Applicatie Ontwikkelaar met PL/SQL Application Developers Database Administrators Database Beheerder Database Designers Forms Developer PL/SQL Developer Prerequisites Required Prerequisites Oracle Database 10g: Introduction to SQL - LVC Oracle Database 10g: PL/SQL Fundamentals - LVC Course Objectives Write dynamic SQL for more coding flexibility Design PL/SQL code for predefined data types, local sub-programs, additional programs and standardized constants and exceptions Use the compiler warnings infrastructure Manipulate large objects Create triggers to solve business challenges Manage dependencies between PL/SQL sub-programs Schedule PL/SQL jobs to run independently Create stored procedures and functions

Download Oracle Database 10g: Develop PL/ SQL Program Units - LVC.Pdf