Home Oracle Form
|
Oracle Form
Oracle Form
  • Oracle Forms is an application development tool for building  client-server database applications. Three components are employed while building applications for Oracle :
  • Oracle Form Designer  : Set of visual tools that create objects, set their properties and let you write codes for your applications.
  • Oracle Forms Generate: Compiles the application file with all of its code objects and creates  an .fmx runfile. 
  • Oracle Forms Runform: Form operators use this runform to run ready Oracle Forms applications.

Apart from the above components, there exist three types of modules, which are  forms, menus and libraries. By the integration of these modules, complete applications could be built.

 

Forms Runtime Environment :

·          Client/Server vs WebForms vs Web Server Applications

–Client: A personal computer

–Server: A computer hosting the RDBMS (Windows, Unix, VMS)

–“Middle Tier”: A computer running the Forms Server and a web server   (Apache or IIS).

–Web Server: Oracle HTTP Server (Apache)

–Web Server Form: Dynamic HTML generated by a PL/SQL package (HTML DB)

–Webform: Oracle Developer Form operating in a browser (native JVM or Jinitiator)

–JVM: Java Virtual Machine

  

·          Selection Criteria (personal opinion)

      –Client/Server or WebForms: controlled environment, rich feature set, “traditional application” (small user population, high-volume usage). (Forms 9i do not support Client/Server deployment.)

      –Web Server Forms: uncontrolled or public access, query only, large user population, integration with other web-based applications (large, occasional user population).

 

  •  Form Processing 

      –Insert/update mode

      –Enter Query mode

 

        ·          Form Navigation

 

      –Function Keys

      –Menus

      –Toolbars

  

·          Forms Programming

 

o         Components

     1. Form

     2. Blocks

     3. Items

     4. Canvases

     5. Windows

     6. Attached Libraries

     7. Relations

     8. Non-Base table blocks

     9. More Triggers

     10. Visual Attributes

     11. Alerts

     12. Record Groups

     13. List of Values (LOV)
 

Polls

More information required for below categories?