Oracle Database 10g: Develop PL/SQL Program Units

This course is designed for developers with basic PL/SQL and SQL language skills. In class students learn to develop, execute and manage PLSQL 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 Functions
• Manage Dependencies and Large Objects
• Create Packages and maintain them
• Create and apply Triggers
• Utilizing Oracle-Supplied Packages in Application Development
• Understand and influence the PL/SQL Compiler

Audience:

• Database Beheerder
• Applicatie Ontwikkelaar met PL/SQL

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
• Design PL/SQL packages to group and contain related constructs
• Create overloaded package sub-programs for more flexibility
• Categorize the Oracle supplied PL/SQL packages
• Use the Oracle supplied PL/SQL packages to generate screen output, file output, web output, and mail output

Required Prerequisites:

• Oracle Database 10g: Introduction to SQL
• Oracle Database 10g: PL/SQL Fundamentals