Oracle Forms Developer's Handbook

Oracle Forms Developer's Handbook

3.88 (17 ratings by Goodreads)
By (author) 

List price: US$88.99

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks


Designed for database developers, programmers and database administrators.

The only book on Oracle Forms that covers the product while showing readers how to create actual, working, powerful applications using Oracle Forms, updated to include all the new web-based and web-oriented features of Oracle Forms 6i. Oracle Forms is the single most important tool used to create sophisticated client/server applications for Oracle databases. Oracle proclaims that the Internet changes everything. And so it does. Recent versions of Oracle's Forms have moved the tool from strictly a client-server based product to a client-server and web-based product. This book updates the other Lulushi books to include Internet based development. This version is so current that it includes coverage right up to Forms version 6i (scheduled for release in Summer 2000). (Note: All other editions/versions of Lulushi's Forms books will remain in print, to accommodate the existing installed base.
show more

Product details

  • Paperback | 1008 pages
  • 180.34 x 233.68 x 68.58mm | 1,882.4g
  • Prentice Hall
  • Upper Saddle River, United States
  • English
  • 0130307548
  • 9780130307545

Table of contents


1. Developing the First Form.

The Equipment Tracking System. Creating the First Form. The Object Navigator. Creating a Data Block with the Data Block Wizard. The Layout Wizard. Adding a Detail Block. Compiling the Module. Summary.

2. Running the First Form.

Running Modules Within the Form Builder. Developer/2000 Forms Runtime Window. Querying the Database. Normal Mode and Query Mode. Manipulating the Database. Transactions in Developer/2000 Forms. Multi-User Applications and Record Locking. What Is Missing in ETS? Summary.

3. Enhancing the First Form.

Transforming the Form into a Tabbed Layout. Arranging Items in the Layout Editor. Enhancing the GUI Interface. Adding Calculated Items. Enhancing the Functionality of Applications with PL/SQL Code. Deploying the ETS Application. What Is the Rest of the Book About? Summary.


4. Oracle Developer Form Builder.

Overview of Oracle Developer. Components of Oracle Developer. Overview of the Form Builder. Working with Modules. Storing Modules in the Database. Summary.

5. Object Navigator.

Accessing the Object Navigator. Components of Object Navigator. Form Builder Object Types and Object Instances. Getting Around Object Navigator. Manipulating Objects in Object Navigator. Different Views of Objects in Object Navigator. Customizing the Object Navigator. Summary.

6. Layout Editor.

Accessing the Layout Editor. Components of the Layout Editor. Working with Objects in Layout Editor. Setting Visual Attributes in the Layout Editor. Customizing the Layout Editor. Customizing Color Palettes. Summary.

7. Property Palette, Menu Editor, and Object Editor.

The Property Palette. Components of Property Palettes. Using the Property Palette. The Menu Editor. Components of Menu Editor. Using the Menu Editor. The Library Editor. Components of the Library Editor. Using the Library Editor. Summary.

8. RAD and Object Reusability.

Overview of Rapid Application Development. Object Reuse in Oracle Developer. Object Groups. Property Classes. Visual Attribute Groups. Practical Examples. Oracle Designer Reusable Components. Summary.

9. Introduction to SQL.

Brief History of SQL Language. Movie Rental Database. Categories of SQL Commands. Data Retrieval with SELECT. Expanding Queries with Set Operations. Data Manipulation Language Commands. SQL Functions. DUAL Table. Summary.

10. Introduction to PL/SQL.

Overview of PL/SQL. Procedural Constructs of PL/SQL. Data Types and Variables. Cursors in PL/SQL. PL/SQL Program Units. Exception Handling. PL/SQL in Form Builder. The PL/SQL Editor. Summary.

11. Object-Relational Oracle8 and PL/SQL.

Overview of the Object-Relational Technology. Object Types and Object Instances. Storing Objects in the Oracle8 Database. Collections. Summary.


12. Object-Oriented Analysis and Design.

Movie Rental Database Problem Restated. Object-Oriented Terminology. Structured Design versus Object-Oriented Design. Designing the MRD Application. User Interface Design and Conventions. Summary.

13. Data Blocks, Frames, and Relations.

Types of Blocks. Creating and Maintaining Data Blocks. Defining and Maintaining the Layout of Blocks. Maintaining Block Properties in the Form Builder. Maintaining Block Properties Programmatically. Frames. Relations. Blocks and Relations for the MRD Application. Summary.

14. Items and Data Items.

Types of Items. Creating Items. Generic Properties of Items. Setting Properties of Items at Runtime. Validation of Items. Text Items and Display Items. Calculated Items. Events of Text Items. GUI Guidelines for Data Items. Data Items in the MRD Application. Summary.

15. GUI Control Items.

Push Buttons. Radio Groups and Radio Buttons. Check Boxes. List Boxes. GUI Guidelines for Controls. Controls in the MRD Application. Summary.

16. Windows, Canvases, and Dialog Boxes.

Properties of Windows. Developing MDI Applications with Form Builder. Alerts. Canvases. Canvas Use Cases. Windows and Dialog Boxes in the MRD Application. Summary.

17. Record Structures and Other Objects.

Records in Form Builder Applications. Record Groups. Lists of Values. Text Editors. Parameters and Parameter Lists. Summary.

18. Menus and Toolbars.

Form Builder Menus. Toolbars. Pop-up Menus. Summary.

19. PL/SQL Objects.

Events and Triggers in Form Builder Applications. PL/SQL Libraries. Creating a Package for the MRD Application. Stored Program Units and Database Triggers. Oracle Designer Server API. Summary.


20. Debugging.

Accessing the Debugger. Components of the Debugger. Managing Debug Actions. Forms Runtime Diagnostics (FRD). Summary.

21. Creating Integrated Developer Applications.

Creating Multiple-Form Applications. Integrating Tools with RUN_PRODUCT. Integrating Form Builder with Report Builder. Integrating Form Builder with Graphic Builder. Summary.

22. Developer Reusable Components.

Overview of Developer Controls. Calendar Control. Hierarchy Browser Control. Wizard Control. Summary.

23. Managing Developer Projects.

Overview of the Project Builder. Managing Projects with the Project Builder. Customizing the Project Builder. Delivering Projects. Summary.

24. Developer Forms for the Web.

What Is the Network Computing Architecture? Developer Forms' Three-Tier Architecture. Implementing Developer Forms on the Web. Special Considerations for Deploying Developer Forms on the Web. Summary.

25. Creating Forms with Designer.

Modules in Designer. Structure of Modules. Working with Modules. Creating and Maintaining Module Elements. Module Wizards. Reusable Components. Summary.

26. Generating Designer Modules.

Repository-Based Software Development. Maintaining Preferences. Object Class Libraries. Generator Templates. Designer Front-End Generators. Summary.


27. Dynamic Data Exchange.

What Is DDE? DDE in Developer Tols. Examples of DDE with Form Builder. Summary.

28. COM-Based Technologies.

What Is COM? OLE Documents Technology. In-Place Activation of Embedded Objects. Linking Objects in Form Builder. Linking and Embedding in the Layout Editor. Manipulating Compound Documents Programmatically. Summary.

29. Automation and ActiveX Controls.

Automation. Automation in Form Builder. Software Components. ActiveX Controls. Summary.

30. Foreign Function Interface.

Types of Foreign Functions. Sample Foreign Functions. User Exit Interface. PL/SQL Foreign Function Interface. Summary.

show more

About Albert Lulushi

ALBERT LULUSHI is a leading Oracle developer and founder of Belacorp, Inc., an IT consulting firm specializing in planning and implementation of data warehousing, e-commerce and Web-based solutions. His most recent experience includes architecting and implementing Operation Support Systems for Nortel Networks; defining the strategic IT plan for Intel Online Services, Intel's billion-dollar e-business initiative; and designing an enterprise-wide asset management solution for Thomson Corporation, a multi-billion global publishing conglomerate. His recent Prentice Hall books include: Developer 2000: The Practitioner's Guide, Inside Oracle Designer/2000, and Developing Oracle Forms Applications.
show more

Rating details

17 ratings
3.88 out of 5 stars
5 41% (7)
4 29% (5)
3 18% (3)
2 0% (0)
1 12% (2)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X