Oracle Database 10g Program with PL/SQL - Part II Study Guide

1-4188-4797-6 © 2006 Publish date: March 10, 2005 311 pages

Buy Now: $119.99

Course ID: oracle-db-10g-plsql-ii-sg

If you've already completed the first part of this course, move on to part two of our computer training books covering database programming with Oracle PL/SQL. The Oracle Database 10g Program with PL/SQL - Part II study guide picks up where part one left off giving you further coverage of the database programming language. In this course, you will explore the grammar, syntax, and features and benefits of using PL/SQL within an Oracle database environment.

This course is completely self-directed putting you in full control of your studies. The Oracle Database 10g Program with PL/SQL - Part II courseware is ready for you when you are ready to tackle these complex topics. You do not need to attend a lengthy or expensive course to learn these programming skills. Simply follow the course and participate in the included activities and take charge of your learning.

This study guide covers a great deal of content and will take a typical student about three days of focused studies to complete. If you want to accelerate your learning and move at a faster pace, you can. If you want to slow down and thoroughly absorb each concept, you can do that too. The Oracle Database 10g Program with PL/SQL - Part II courseware is easily adaptable to fit any schedule.

Course Objectives

By the end of this course, you will be comfortable using PL/SQL in a database environment and understand its advantages. You will also understand program variables, complex data types, logic within PL/SQL program blocks, data retrieval into program variables, how to return program output to users, how to handle program exceptions, explicit and implicit database cursors, and the advanced features of nested blocks and sub-programs.

Course Contents

An introduction to database program units

• Database program units
• PL/SQL program units types
• Stored program units types
• Stored program units advantages

Building stored procedures and functions

• An overview of stored procedures and functions
• Building procedures and functions
• How to execute procedures and functions
• How to handle compilation errors

Stored procedures and functions maintenance

• An overview of application maintenance
• Recompiling and dropping programs
• Data dictionary storage
• How to manage dependencies

Building and maintaining packages

• An overview of packages
• Building packages
• Maintaining packages
• Working with advanced programming techniques
• Considerations for performance

Cursor variables

• An overview of cursor variables
• Working with cursor variables
• Working with SYS_REFCURSOR

System-supplied packages

• An overview of system-supplied packages
• Working with DBMS_OUTPUT()
• Working with UTL_FILE()

Database triggers

• An overview of database triggers
• Trigger execution
• How to develop trigger logic
• Implementing triggers
• Working with row triggers
• Trigger processing
• Trigger examples

Maintaining database triggers

• Features
• Maintaining existing triggers
• “Instead of” triggers
• Data dictionary storage

System event triggers

• An overview of system event triggers
• Attributes of system events
• Required privileges
• Grant example