ORACLE 9i DEVELOPER SUITE FORMS & REPORTS
 
Oracle 9iDS Reports: Build Internet Reports
 

Course duration(in hrs): 28

Course Objectives:

  1. Use iSQL*Plus to format reports

  2. Use basic iSQL*Plus commands

  3. Retrieve, insert, update, and delete data

  4. Describe relational and object relational database concepts

  5. Create and maintain database objects

  6. Control transactions

  7. Control data and user access
 
Course Topics
 
Reports Storage Methods

  1. Storage Methods and Requirements

  2. Sharing Reports Among Developers

  3. Converting Between Storage Types

  4. Documenting Reports

  5. File Types and Portability
Enhancing Reports Using the Data Model: Creating Queries and Groups

  1. The Data Model Objects

  2. Changing the Group Structure

  3. Ordering Data in a Group Using the Break Order Property

  4. Eliminating Data Using Group Filters

  5. Adding New Data

  6. Linking Data from Different Queries Using a Data Link
Enhancing Reports Using the Data Model: Creating Columns

  1. Maintaining Database Columns

  2. Using a Database Column

  3. Creating Summary Columns

  4. Creating Formula Columns

  5. Creating Placeholder Columns
Controlling the Paper Layout : Common Properties

  1. Controlling the Print Direction of a Repeating Frame

  2. Controlling Pagination of a Repeating Frame

  3. Controlling Spacing Between Records

  4. Creating New Fields in the Layout and Modifying the Properties
Creating & Using Report Parameters and Customizing a Parameter Form

  1. Creating User Parameters

  2. Referencing User Parameters

  3. Creating Lists of Values for Parameters

  4. Referencing System Parameters

  5. Creating a Parameter Form Layout

  6. Customizing the Parameter Form Layout
Enhancing Matrix Reports

  1. The Matrix Data Model

  2. The Matrix Layout Model

  3. Creating Matrix Summaries

  4. Creating a Nested Matrix Report Using the Wizards
Embedding a Graph in a Report

  1. Creating and Embedding a Graph in a Report

  2. Using a Graph Hyperlink

  3. Summary
Coding PL/SQL Triggers in Reports

  1. Trigger Types

  2. Creating Report Triggers

  3. Creating Data Model Triggers

  4. Creating Layout Model Triggers

  5. Writing Common Code
 
 
 
     
 
Training Portfolio
 
 
Courses
Course material designed by experts
Tutorial
Certification Guidance
 
 
—————————————————
  
     
     
     
 
 
     
© 2009, qsoftindia.com, All Rights Reserved
`