Skip to content

Programming with Oracle Developer

Spend $50 to get a free DVD!

ISBN-10: 0672321106

ISBN-13: 9780672321108

Edition: 2002

Authors: Joe Duer, Matthew Bennett

List price: $49.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

This text explains how to create Oracle forms, reports and graphic displays for both a client/server platform and for deployment on the Web.
Customers also bought

Book details

List price: $49.99
Copyright year: 2002
Publisher: Sams
Publication date: 9/17/2001
Binding: Paperback
Pages: 360
Size: 7.50" wide x 9.00" long x 1.00" tall
Weight: 1.342
Language: English

Introduction
Oracle Developer
Oracle Forms and Reports--Overview and Architecture
History of Oracle's Development Tools
Before the Days of Graphical User Interfaces
Client/Server Computing
The Birth of Web-Based Applications
Advantages of Client/Server over Web-Based Applications
Components of the Oracle Internet Developer Suite
Oracle Designer and Repository
Oracle Forms Developer
Oracle Reports Developer
Oracle JDeveloper
Oracle Discoverer
Oracle Portal
Oracle Forms Developer
Forms Compiler and Forms Runtime
Oracle Forms Server
Oracle Reports Developer
Oracle Reports Compiler and Runtime
Oracle Reports Server
Tools Common to Both Forms and Reports
Graphics Builder and Runtime
Query Builder
Schema Builder
Procedure Builder
Project Builder
Translation Builder
The Oracle Database Server's Role in Forms and Reports Development
PL/SQL
Java
Objects
Deployment of Forms and Reports
The Three-Tiered Model
Summary
Developer Basics
Installation
Operating System Requirements
Hardware Requirements
Database Server Requirements
Installation Help for Microsoft Windows
Installation on Unix
Installing the Sample Tables
Using Forms Developer
Building Your First Form
Running Your Form
Building Complex Forms
Using Reports Developer
Creating Your First Report
Building Complex Reports
Using Oracle Graphics
Your First Graph
Complex Charts and Graphs
Summary
Oracle Forms Developer
Creating a Master-Detail Form Using the Forms Builder
Master-Detail Relationships
Starting a Master-Detail Form
The Object Navigator and Property Palette
Adding the Detail Block
Using the Re-Entrant Layout Wizard
Master-Detail Forms in the Runtime Environment
Using the Layout Editor
Moving Objects
The Layout Editor Toolbars
The Layout Editor Visual Tools
The Layout Editor Ruler and Grid
A More Detailed Look at the Object Navigator
Summary
Oracle Reports Developer and Graphics
Creating a Master-Detail Report Using Report Builder
Using Query Builder to Create Database Queries
Using the Re-entrant Layout Wizard
Using the Report Editor
Using the Object Navigator
Integrating Graphics into Reports
Summary
Query Builder and Schema Builder
More About the Query Builder
Running Query Builder
Creating Lookup Queries
Creating Table Relationships
Saving the Query
The Query Window Toolbar
More Examples
The Results Window Toolbar
Query Builder Conclusion
The Schema Builder
Creating a Table
Creating Relationships
Creating Indexes
Schema Builder Toolbar
Creating Integrity Constraints
Creating Views
Summary
Writing Source Code with Developer
Procedure Builder and PL/SQL
Role of PL/SQL in Developer
Procedure Builder
The Program Unit Editor
The PL/SQL Interpreter
The Object Navigator
The Syntax Palette
The PL/SQL Language
Declaring and Using Variables
Integrating with SQL
Common Language Constructs
Functions
Packages
Database Triggers
Handling Exceptions
PL/SQL in Developer
Summary
Using Java with Oracle Developer and the Oracle Database
Mixing Java and Oracle
Creating Stored Procedures with Java
A Simple Stored Procedure
Using SQL with Java Stored Procedures
Dropping a Stored Procedure Written in Java
Using Java with Oracle Developer
Summary
Application Development with the Developer Tools
Using Graphical Elements in Forms
The Forms Runtime Environment
The Visual Runtime Environment
Hidden Features of the Runtime Environment
A Final Word About the Runtime Environment
Creating a Form Manually
Calculation Fields
Wizards Make Life Easier
Various Visual Elements
Static Images
Push Buttons
List Items
Check Boxes
Radio Buttons and Groups
Chart Wizard
Running the Form in the Debugger
Canvases
List of Values
Dialog Boxes
Summary
More About Reports
Report Examples
Tabular Reports
Form-Like Reports
Mailing Label Reports
Form Letter Reports
Group Left Reports
Group Above Reports
Matrix Reports
Matrix with Group Reports
Report Views
Live Previewer
Data Model
Layout Model
Creating and Modifying Report Templates
Modify an Existing Template
Creating a New Template
Template Summary
Parameter Forms
Summary
Oracle Graphics Builder Development
Chart Types
Bar Charts (Both Horizontal and Vertical)
Line Charts
Pie Charts
Table Charts
Mixed Bar and Line Charts
Double-Y Charts
Scatter Charts
High-Low Charts
Gantt Charts
Chart Type Summary
Drill-Down Charts
Summary
Developer Application Design
Application Background and Requirements
Application Interface
Forms
Reports
Graphics
Review by Big Jim
Database Objects to Create
Tables and Sequences
Indexes
Creating the Database Schema
Summary
Making the Design a Reality
Forms Creation
Three Maintenance Forms
The Events Form
The Signup Form
The Results Entry Form
Reports Creation
The Confirmation Letter
The Results Report
Graphics Creation
Creating a Menu
Possible Enhancements
Summary
Deployment and Optimization of Developer Applications
Deploying Developer Applications to the Web
Understanding Web Deployment of Developer Applications
Forms Server Architecture
Reports Server Architecture
Deploying Forms on the Web
Deploying Reports and Graphics on the Web
Using Java with Your Developer Application
Using Java Stored Procedures and Functions
Java Beans in Forms
Summary
Project Management and Source Code Control
Project Builder
Creating and Adding Files to Project Builder
Building Files with Project Builder
Using the Delivery Wizard
Customizing Project Builder with the Module Type Wizard
Source Code Control
Sample Source Code Control Systems
Source Code Control Using Project Builder
Summary
Guidelines for Building Great Developer Applications
Tuning the Look and Feel
Visual Aspects
Usability
Performance Tuning
All Applications
Forms
Reports
Graphics
Web Deployment
A Final Note on Performance
Developing Multilingual Applications
Considerations
Multilingual Application Caution
Writing Portable Applications
Colors
Fonts
Key-Specific Messages
Summary
Index