Oracle Forms Training
Oracle Forms is an application that interacts with an Oracle database by creating data entry screens, its primary focus. Added are a variety of graphical user interfaces, or GUIs, such as buttons, menus, scrollbars, and graphics to provide end users with a productive and positive experience.
Other People Are Reading
-
Oracle Forms History
-
Oracle Forms is Oracle's long-established technology that was first conceived in the late eighties to design and build enterprise applications for interacting with databases quickly and efficiently. Oracle Forms is part of the Oracle Developer Suite, which presents an organized method to view and edit database-driven applications.
Form Modules
-
A Form Module presents the objects and data that end users can interact with and visually see. The Forms Builder provides a default menu for every form---the commands that are included are very basic---if your application has specific requirements you will need to create a custom menu. The module contains a library of program units written in Oracle's Procedural Language/Structured Query Language. The PL/SQL Library's code is attainable to use when referenced and called from other modules. An object library is a collection of form objects that are reusable in other modules.
-
Modes of Operation
-
There are three modes of operation in the Forms builder: Enter-Query mode, Normal mode and Query mode. Use the Enter-Query mode to search the database and retrieve restricted data. Use the Normal mode to insert and alter records in the database. The Query mode generally occurs while Forms is processing a query---no user interaction is taking place while this the query mode is processing.
Forms Components
-
An item is an interface object that presents a data value to the end-user or enables the end-user to interact with the form, based on the item type. Items are grouped logically into blocks and visibly arranged on canvases.
Blocks provide a mechanism for grouping related items into a functional unit for storing, display and manipulating records.
A canvas is a surface inside a window container on which you place visual objects, such as interface items and graphics. To see a canvas and its contents at run time, you must display it in a window. A canvas always displays in its assigned window. Forms Builder offers four different types of canvases. A content canvas type is the base canvas and the default canvas that occupies the entire content pane of the window in which it displays. Oracle Forms Builder's three other types of canvases are the stacked canvas, the toolbar canvas and the tab canvas.
Forms Concepts
-
Events cause the activation, or firing, of certain trigger types. Each trigger defined is associated with a specific event, which includes a query-related event, data event and validation, logical or physical navigation, operator interaction with items in the form, internal events in the form and errors and messages.
Triggers are one of the most important mechanisms used to modify or add to the functionality of a form. A trigger is a program unit executed based on an event. The Forms Builder permits the construction of powerful facilities into applications without writing a single line of code. By writing Forms Builder triggers in PL/SQL, you are able to define a detailed process in an application.
-
References
- Photo Credit computers screen 2 image by chrisharvey from Fotolia.com
