Oracle Forms Tutorial in bangla Creating LOVs

We will learn how to create LOVs in oracle forms.

Steps are given below.....

Step 1: create a table wher you want to input data which will come from a table.(creating LOVs)

Step 2:Sart OC4j and run Form Builder and then connect for creating LOVs.

Step 3: Create a data block and select your created table for creating LOVs.

Step 4: now create a lov from the object navigator for creating LOVs.

Step 5: build a sql query with your table column and another table from which you will retrieve data. by creating LOVs.

Step 6: then ok. For creating LOVs.

Step 7: Compile your form and run for creating LOVs

Step 8: after opening the browser just press CTRL+L . your lov will show..

Step 10: Now you can also show your lov by a button. for creating LOVs.

Step 11: select WHWN-BUTTON-PRESSED trigger for showing LOVs .

Step 12: use "SHOW_LOV' built-in object in your trigger.

Step 9: Select your value ..then save

Thanks For Watching......
Subscribe my channel and stay connected with my tutorials.

Md.Mahfujur Rahman
Database Design and Development.