CIS 399 - Introduction to Oracle and SQL

Week 6 Lecture Notes

Monday, July 31 2006

1. Simple Forms Continued:
   1. Lookup Columns - converting IDs to useful values
      1. page 394, Listings example
   2. Creating a List of Values - useful for searches, VERY similar to just using a view
      1. page 395-398, Listings example
   3. Automating the Execute Query Step
      1. page 398, Listings example
   4. Radio Buttons and Check Boxes
      1. page 398-401, Properties example
2. Tabular Forms
   1. Creating Tabular Forms
      1. page 402, LicenseStatus example (build whole thing)
   2. Creating Main and Sub Forms
      1. page 403-405, AgentContacts example (show finished, build whole thing)
   3. Adding Display Columns for the Grid
      1. page 406-407, AgentContacts example (continue building)
   4. Setting Format Masks
      1. page 407, AgentContacts example (continue building)

Tuesday, August 1 2006

1. Announcements: new homework
2. Working without the Wizards
   1. Creating a Canvas
      1. page 415-417, Search example (build some of it)
   2. Creating a Simple Data Block for a query
      1. page 418-419, Search example (build some of it)
   3. Creating an "Execute" button to run the query
      1. page 420-421, Search example (build some of it)

Wednesday, August 2 2006

1. Form Triggers
   1. Form Events

      ENTER Form	ENTER Block	ENTER Item
      Pre-Logon
      On-Logon
      Post-Logon
      Pre-Form
      	When-Create-Record
      	Pre-Block
      	Pre-Record
      		Pre-Text-Item
      When-New-Form-Instance
      	When-New-Block-Instance
      	When-New-Record-Instance
      		When-New-Item-Instance
      EXIT Form	EXIT Block	EXIT Item
      		Post-Text-Item
      	Post-Record
      	Post-Block
      Post-Form
      On-Rollback
      Pre-Logout
      On-Logout
      Post-Logout

   2. Creating Triggers
      1. page 424, Agents example (changes into Agents2)
   3. Debugging Triggers
      1. page 424, Agents example (changes into Agents2)
   4. Handling Errors
      1. page 424, Agents example (changes into Agents2)
   5. Scope and Lifetime of Variables
2. Useful Forms Tools
   1. Creating Sequences
   2. Validating Form Input
   3. Computing Subtotals for Grid Data
3. Using Multiple Canvases
   1. Adding a Canvas
   2. Stacked Canvas
   3. Tab Canvas
   4. Form Styles

Thursday, August 3 2006

1. Introducing Reports Developer
   1. Web Publishing and Paper Reports
   2. Types of Reports
      1. Tabular Report (simple listing)
      2. Group Report (control break)
      3. Matrix Report (cross tab)
      4. Mailing Labels
   3. Oracle Reports Services
2. Building and Modifying Reports
   1. The Report Structure
   2. The Reports Builder
   3. The Paper Design and Layout Windows
   4. The Object Navigator Window
   5. Enhancing a Report
   6. Aligning and Justifying Columns
   7. Setting Format Masks and Properties
   8. Adding Shading and Borders
   9. Inserting Page Numbers and Dates
   10. Adding Text Boxes
3. Customizing Reports
   1. The Data Model
   2. Adding Fields
   3. Data Group Structure and Frames
   4. Creating a Report Manually
   5. Displaying Images from the Database
4. Controlling Data in a Report
   1. Creating User Parameters
   2. Using Filters to Limit Reports
5. Creating Custom Templates
   1. Designing Custom Templates
   2. Applying Templates
   3. Registering Templates
6. Customizing a Web Report
   1. The Dynamic Report Environment
   2. Modifying a Web Report
   3. Adding a Chart to a Report

Answers to Questions / Clarifications

Back to Main Page