Скачать или смотреть Oracle Forms || How to Search || Bangla (22)

Oracle Forms || How to Search || Bangla (22)
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 SEARCH manually as your wish by any column at run time in oracle forms .
You can to SEARCH by using WHEN-BUTTON-PRESSED or KEY-NEXT-ITEM Trigger.

Code:
if :SEARCH_TYPE=1 then
go_block('EMPLOYEES');
set_block_property
('EMPLOYEES',onetime_where,'employee_id=:SEARCH_EMP');
execute_query;
elsif
:SEARCH_TYPE=2 then
go_block('EMPLOYEES');
set_block_property
('EMPLOYEES',onetime_where,'department_id=:SEARCH_EMP');
execute_query;
elsif
:SEARCH_TYPE=3 then
go_block('EMPLOYEES');
set_block_property

('EMPLOYEES',onetime_where,'upper(last_name) like '||'''%'||upper(:CONT.SEARCH_EMP)||'%''');
execute_query;
elsif
:SEARCH_TYPE=4 then
go_block('EMPLOYEES');
set_block_property
('EMPLOYEES',onetime_where,'hire_date=to_date(:SEARCH_EMP)');
execute_query;
end if;

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