(See related pages)
This chapter explains the motivation and design issues for stored procedures and triggers and provides practice writing them using PL/SQL, the database programming language of Oracle. After this chapter, the student should have acquired the following knowledge and skills:
|
|
|
Explain the reasons for writing stored procedures and triggers. |
|
|
|
Understand the design issues of language style, binding, database connection, and result processing for database programming languages. |
|
|
|
Write PL/SQL procedures. |
|
|
|
Understand the classification of triggers. |
|
|
|
Write PL/SQL triggers. |
|
|
|
Understand trigger execution procedures. |