What is an SQL *FORMS?

What is an SQL *FORMS?

SQL FORMS as known previously and SQL * FORMS in version 2, is more or less like an interface to interact with the oracle database. The form is in *.fmb format and compiled into an executable (*.fmx). These forms provide a means to add GUI elements like scroll bars, menus etc and reduce the efforts of writing complex queries.

What is an SQL *FORMS?

- Oracle Forms is part of Oracle's Internet Developer Suite. Its earlier versions were called SQL*Forms.

- Oracle Forms is a 4GL Rapid Application Development (RAD) environment.

- A Forms Builder is used to create applications to enter, access, change, or delete data from Oracle databases.

- The Forms Runtime environment is needed to execute compiled Forms modules.
How do you control the constraints in forms?
You can suppress or customize error messages in Forms. This can be done by setting the message level of the system variable SYSTEM.MESSAGE_LEVEL....
When will ON-VALIDATE-FIELD trigger executed?
ON-VALIDATE-FIELD triggers are used for field validation. It fires when the field validation status is New or changed.......
Difference between system.current_field and system.cursor_field
The only difference between these two is that System.current_field gives name of the field and System.cursor_field gives name of the field with block name..
Post your comment