| 6 | 7 | 8 | 9 | 10 | |||||
| 16 | 17 | 18 | 19 | 20 | |||||
| 26 | 27 | 28 | 29 | App |
Why Don’t They Use Oracle Developer?
The Scope of the Book
Who Should Read this Book?
How This Book is Organized
Where Do You Go From Here?
A Review of the Developer Forms Data Architecture
Sample Files
What If You Are Skipping Release 2?
Developer 6 Support for Oracle8
Form Builder New Features
Report Builder New Features
Why Coding Standards?
Enforcing the Standards
General Coding Standards
SQL Coding Standards
PL/SQL Coding Standards
Strategy Document Example
Forms Query Text
Basing a Block on Nothing (a Control Block)
Basing a Block on a Table
Basing a Block on a View
Basing a Block on a Procedure
Basing a Block on a FROM Clause Query
Basing a Block on Transactional Triggers
The Forms Development Process
Guidelines for Forms Development
Forms Layout Editor Tips and Techniques
Miscellaneous Forms Standard Techniques
Why Name Forms Objects?
Naming Convention Considerations
Naming Conventions for Specific Objects
Standards for Code Placement
Packages or Stand-Alone?
Database Server or Form?
Handling Forms Functions
Trigger or Program Unit?
Form or Library?
Which Library?
Subclass or Copy from the Object Library?
Which Level of Trigger?
The Development Process
General Guidelines
Genericizing Reports
Setting the Report Standards
Naming the Report Itself
Naming Queries
Naming Groups
Naming Frames
Naming Display Fields
Naming Program Units
Naming Boilerplate Items
Forms and VRAD
What is a Template Form?
Form Builder Features Used in the Template
Template System Architecture
How to Use the Template
The Process
Genericizing Objects and Code
Object Library Elements
Other Template Tasks
Style-Specific Templates
1. Install the Template
2. Create a New Form
3. Add Data Objects
4. Apply SmartClasses
5. Modify the Template Code
6. Add Other Objects
7. Add Other Code
The Web-Deployed Forms Environment
Oracle Information Manager Documents
General Advice
Techniques and Considerations
How Much Help?
Native Forms Help
Table-Based Help
WinHelp Help System
What’s This?
Other Help Alternatives
Design of the Locator Items
Implementing Locator Query Criteria
Querying by Generic Items
Locator Results Block
Check Boxes
Radio Groups
List Items
Lists of Values (LOVs)
Calling Reports from Forms
Bind Variables and Lexical Parameters
Report Builder Architecture
Advanced and Underused Features
Report Wizard
Data Model
Layout Model
Object Navigator
Crafting the Query – Keep it Simple!
Non-Query Fields
Groups
Working with the Layout Model
Anchors: Keeping Things Where They Belong
Format Triggers
Overview
Template Structure
Building a Sample Template
Setting Report Template Standards
Preparing to Build the Report
Step 1: Select the Report Style
Step 2: Connect to the Database
Step 3: Build the Query – Selecting Tables
Step 4: Build the Query – Selecting Columns
Step 5: Build the Query – Modify SQL Code
Step 6: Build the Query – Selecting Fields for Breaks
Step 7: Display Definition
Step 8: Summary Columns
Step 9: Labels
Step 10: Template Selection
Step 11: Add a Query
Step 12: Select Columns
Step 13: Alias the Column Names
Step 14: Create Break Groups
Step 15: Rename Groups and Queries
Step 16: Create Summary Columns
Step 17: Link Queries
Step 18: Create the Report Layout
Step 19: Select Groups and Modify Settings
Step 20: Change the Layout by Using the Live Previewer
Step 21: Add Information to the Report
Step 22: Create a Function
Step 23: Add the Employee Information
Step 24: Apply the Template
Step 25: Add Totals
Step 26: Fine-tune the Report Layout
Step 27: Complete the Report
Oracle Developer Expertise
About the Interview Questions
Oracle Forms Interview Questions
Oracle Reports Interview Questions
Scoring Your Answers
Page Breaks
Control of Page Layout on a Form-Style Report
Complex Centering of a Report
Strategies for Using Dot Leaders
Managing Reports with Forms
Alternating Page Headings
Counts of Record Subsets
Basing a Query on a Function
Performance Optimization in Reports
Hierarchical Tree Control
Dynamic Poplists
System-Assigned ID Value
Loading Image Items
Access Keys for Text Items
Characters as Button Icons
Naming the Block Your Way
Dynamic Block Filtering
Dynamic Block Sorting
Handling Forms Errors and Messages
An Alert System
Looping Through Objects
Tuning Your Forms
Finding Code and Objects in a Form
Changing the Cursor Shape
Calling Other Forms
Calling Other Programs
Other Tips and Techniques
Techniques for Building Menus
Menu Toolbars
Implementing Menu Security
Dynamic Toolbars and Menus
Sharing Variables
Compiling Forms Files
Setting Forms Registry Values
Foreign Function Interface (FFI)
Which Files Does Oracle Installer Install?
Last updated 2 May, 2000