1 Introduction to Oracle Developer Copyright Oracle Corporation

1 Introduction to Oracle Developer Copyright Ó Oracle Corporation, 1999. All rights reserved.

Objectives After completing this lesson, you should be able to do the following: •

What Is Oracle Developer? Supported technologies Family of products Oracle Designer GUI Database Oracle

Key Features • • 1 -4 Comprehensive GUI support Distributed applications Productive and comprehensive

Improved Developer Productivity Release 6 provides: • • • 1 -5 Wizards Visual query

Oracle Developer Components API Translation Builder Project Builder Form Builder Report Builder Graphics Builder

Common Builder Components 1 -8 Copyright Ó Oracle Corporation, 1999. All rights reserved.

Form Builder Layout Editor Toolbar Tool Palette 1 -9 Copyright Ó Oracle Corporation, 1999.

Oracle Toolkit and Multimedia 1 Applications Form, Report, Graphics 2 3 4 Microsoft Windows

Getting Started • Start the builders: – Invoke by using the Project Builder launchpad

Main Menu Structure 1 -12 Copyright Ó Oracle Corporation, 1999. All rights reserved.

Customizing Your Oracle Developer Session 1 -13 Copyright Ó Oracle Corporation, 1999. All rights

Saving Tools Preferences 1 2 3 1 -14 Copyright Ó Oracle Corporation, 1999. All

Oracle Developer Environment Variables • • • FORMS 60_PATH REPORTS 60_PATH GRAPHICS 60_PATH UI_ICON

Using the Online Help System • Quick Tour: Built-in CBT package of technical information

Summit Sporting Goods Schema s_ord s_item s_customer s_inventory s_product s_image 1 -17 s_emp s_warehouse

Summit Application CV_Customer Canvas S_CUSTOMER Table S_ORD Table S_ITEM Table S_CUSTOMER Block CV_Order Canvas

Summary • • 1 -19 Oracle Developer common features Common builder interface Builder preferences

Practice 1 Overview This practice covers the following topics: • Becoming familiar with the

Slides: 20

Download presentation

Objectives After completing this lesson, you should be able to do the following: • Describe common features and benefits of Oracle Developer • • • 1 -2 Describe Oracle Developer components Describe common builder components Navigate around the builder interface Customize the Oracle Developer session Describe the course application Copyright Ó Oracle Corporation, 1999. All rights reserved.

What Is Oracle Developer? Supported technologies Family of products Oracle Designer GUI Database Oracle Developer Client-server World Wide Web Oracle Discoverer 1 -3 Copyright Ó Oracle Corporation, 1999. All rights reserved.

Key Features • • 1 -4 Comprehensive GUI support Distributed applications Productive and comprehensive tools Application partitioning Flexible source control Extended scalability Object orientation Copyright Ó Oracle Corporation, 1999. All rights reserved.

Oracle Developer Components API Translation Builder Project Builder Form Builder Report Builder Graphics Builder Procedure Builder Query Builder Schema Builder Database interface 1 -6 Copyright Ó Oracle Corporation, 1999. All rights reserved.

Oracle Developer Components API Translation Builder Project Builder Form Builder Report Builder Graphics Builder Procedure Builder Query Builder Schema Builder Database interface 1 -7 Copyright Ó Oracle Corporation, 1999. All rights reserved.

Oracle Toolkit and Multimedia 1 Applications Form, Report, Graphics 2 3 4 Microsoft Windows 95 Windows NT OSF/Motif 1 -10 Character mode Macintosh Copyright Ó Oracle Corporation, 1999. All rights reserved.

Getting Started • Start the builders: – Invoke by using the Project Builder launchpad – Invoke from individual builder icons • See: – Project Builder: the banner and then the wizard – Other builders: wizard • • 1 -11 Connect to the database. Select File—>Connect. —> Copyright Ó Oracle Corporation, 1999. All rights reserved.

Oracle Developer Environment Variables • • • FORMS 60_PATH REPORTS 60_PATH GRAPHICS 60_PATH UI_ICON ORACLE_PATH Windows NT: Modify in Registry (REGEDIT. EXE or REGEDT 32. EXE) 1 -15 Copyright Ó Oracle Corporation, 1999. All rights reserved.

Summit Application CV_Customer Canvas S_CUSTOMER Table S_ORD Table S_ITEM Table S_CUSTOMER Block CV_Order Canvas S_ORD Block S_ITEM Block CV_Inventory Canvas S_Inventory Block S_INVENTORY Table 1 -18 Customers Form Copyright Ó Oracle Corporation, 1999. All rights reserved. Orders Form

Practice 1 Overview This practice covers the following topics: • Becoming familiar with the Object Navigator and Layout Editor • • Modifing file access preferences 1 -20 Creating executable files by using Project Builder Copyright Ó Oracle Corporation, 1999. All rights reserved.