Oracle Forms | How to create Dynamic List of Values | Bangla (LOV) 21

Опубликовано: 24 Июль 2026
на канале: OracleDB Solutions

1,184

Oracle Forms | How to create Dynamic List of Values | Bangla (LOV)
To See More Forms Tutorial Click here    • Oracle Forms: How to Install Oracle Databa...
To See More Reports Tutorial Click here    • Introduction To Database & Out Line The Se...

Dear viewer, In this tutorial you will learn
how to create DYNAMIC LIST in oracle forms.

Trigger: WHEN-NEW-FORM-INSTANCE in forms level.
Code:
declare
rg_name varchar2(25):='food_name';
rg_id recordgroup;
status number;
begin
rg_id:=find_group(rg_name);
if
not id_null(rg_id) then
delete_group(rg_id);
else
rg_id :=create_group_from_query
(rg_name,'select food_name, to_char(food_id) from food_item');
end if;
status :=populate_group(rg_name);
populate_list('proid',rg_id);
end;

To Get more Tutorial Subscribe The Channel
click here    / @oracledbsolutions2678

To Get All Post Like The Facebook Page
Click here   / oracledbsolutions

Follow us:
Facebook:   / oracledbsolutions
Youtube link:    / @oracledbsolutions2678
Facebook Group:   / 465557066961548

Contact us:
email: [email protected]
Skype: oracle26solutions
Mob: 01734557080, 01627422780