|
|
This course covers the design, creation and implementation of interactive
single forms with multiple canvases. The student will learn how to
create multiple forms and reports using PL/SQL triggers, the Object Navigator,
and Oracle's Form & Report Builders.
Reports and interactive forms will use single and multiple tables in a realistic
business setting.
The student receives extensive hands-on instruction on a Windows-based personal computer.
|
|
|
|
(54 hours lecture; 54 hours lab; Degree appropriate)
|
|
Advisory Prerequisite:
CISD 31 - Database Management - Oracle
|
Course Measurable Objectives:
- Analyze business problems and design appropriate Oracle interactive forms and reports.
- Analyze business forms and design appropriate Oracle forms and report functions and commands.
- Write Oracle PL/SQL trigger functions for client and database servers.
- Develop, write, test, debug and implement a complete Oracle Forms and Report application with PL/SQL triggers on the client and server database.
- Organize, classify and write Oracle application documentation.
|
Course Level Student Learning Outcomes:
Students completing CISD 32 - Oracle Forms and Reports will be able to:
- explain the differences between a Data Block form and a Control Block form.
- determine when to issue an Alert as opposed to a Custom Message to the user.
|
|
|
|
