Example is given for Pre-Query and Post-Query triggers in Oracle Forms, with using Display_Item built-in in Post-Query triggers to highlight fields dynamically. This is the screen shot below for this example: You can also download this form from the following […] More
Hello guys, I have recently started a question & answer forum for developers. That's why I want you all to join this forum. It is totally free. Here you can ask questions and answer questions, and if you have a […] More
Below I am giving two examples to suppress the error messages in Oracle Forms, the first example is to suppress all the error messages and the second example is to suppress all the error messages but handle a specific error […] More
We need to refresh a block in Oracle Forms, when we applied some filter for query or the data have been changed by the other user. If you just applied a filter or you have a doubt that the data […] More
In Oracle Forms, you can make a field mandatory at design time and at the runtime. Examples for both the methods are given below: Make a Field Mandatory at Design Time in Oracle Forms Whenever we create a form based on […] More
If you are working in Oracle Forms having tabular data block or creating a new tabular data block, then you might require to loop through the records due to many reasons. Maybe you need to write a text file by […] More
You can call a database procedure in Oracle Forms as you call in Oracle Database itself using PL/SQL. Below are the examples: Call a Database Procedure in Oracle Forms Examples In the following case, it will simply call a database […] More
Here I am giving two examples to generate the serial number in Oracle Forms using System.Cursor_Record system variable and using Sequence database object. Generate Serial Number Using System.Cursor_Record in Oracle Forms In Oracle Forms, you have a tabular database block, […] More
To get previous record value in Oracle Forms, use Previous_Record built-in. Previous_Record command navigates to the next lower sequence number than the current record. To get the current record number you can use System.Cursor_Record system variable. Below is the example: […] More
In Oracle Forms, to check for the first record use System.Cursor_Record system variable and to check for the last record use System.Last_Record system variable. Below are the examples: Check If First Record in Oracle Forms System.Cursor_Record return the current number […] More
Copyright @2023 - Made with ❤️ by Vinish Kapoor