How to get LOV button in Oracle Forms

 

Step 1:

Before anything else, you must design a form with text fields and a button.

Step 2:

Then choose the LOVs from the menu. Using the vertical toolbar, build the LOVs by clicking on the button in the middle of the screen.

Step 3:

Following the creation of the LOV, you should be presented with a LOV creation window. The first is the LOV Wizard, which automatically generates LOV. The second option is to use LOV manually. As a result, I must generate automatically, which means I must choose the first choice.

Step 4:

LOV is the next window to open. Oracle creates Record Groups depending on the query entered into the wizard in this window. To proceed, click on the next button.

Step 5:

The SQL statement window is the third window. In this box, you must type the SQL query that will be used. Which kind of data are shown in LOVs? (List of Values). After that, click on the Next button.

Step 6:

Window for recording group columns is the fourth one on the list. In this window, you may add the columns from the record group to the LOV columns that correspond to the columns that appear in your List.

Step 7:

The fifth window displays the return value for the column value that was entered in the form text field. It is necessary to display the horizontal scroll bar. Simply reposition it, and the return values columns will be shown. Now, choose the return value columns from the menu and click on the search look up return item button that appears below those columns.

Step 8:

The next box you will see after clicking the look up return item is the items and parameters window, which will return your form field in record groups as the result of your search. After you have made your selections for the columns, click on the next button in the LOV wizard.

Step 9:

The next window allows you to customise the title as well as the width and height of the LOVs runtime window.

Step 10:

The records are being retrieved in the next window. After 20 records have been fetched from the database, it has finished fetching the records. As a result, it does not utilise any database resources. I broke a total of 20 records.

Step 11:

The next step is to allocate LOV. It means that you will be able to allocate your LOV to the text field on the fly. My situation is unique in that I open my LOV on a button rather than assigning it. As a result, I just pressed the Next button.

Step 12:

The last and final window is the finish window. Simply press the "finish" button to complete the process.

Step 13:

Now that LOV has been formed, just go to the button I generated with the name of LOV and hit F11 to create a WHEN-BUTTON-PRESSED trigger for the button. To proceed, press the OK button.

Step 14:

Create the trigger and paste the code I mentioned below. And just pass the LOV name in my case LOV name is LOV10. Now run the form and press List label button.

declare

                a boolean;

begin

                a := show_lov('LOV10');

end;

Output:

I hope it's helpful for you. If you have any queries, don't hesitate to contact me.

Name : Muhammad Sahal Qasim

E-mail : s.m.sahal789@gmail.com

Thank you.