Oracle Forms || How To Create PL/SQL Library -30

Опубликовано: 02 Ноябрь 2024
на канале: OracleDB Solutions

1,620

Oracle Forms || How To Create PL/SQL Library -30
To See More Forms Tutorial Click here    • Oracle Forms: How to Install Oracle D...
To See More Reports Tutorial Click here    • Introduction To Database & Out Line T...

About PL/SQL Library:
A library is a collection of PL/SQL program units, including procedures, functions, and packages. A single library can contain many program units that can be shared among the Oracle Developer modules and applications that need to use them.
Pl/SQL Libraries generally contain procedures, functions and packages.

Create multi_fun in the function:
Code:
FUNCTION multi_fun ( p number, q number)
return number
IS
v_record number(20);
BEGIN
select p * q into v_record from dual;
return v_record;
END;

Create multi_button in the procedure:
Code:
PROCEDURE multi_button IS
BEGIN
IF name_in(':SYSTEM.TRIGGER_ITEM')='CONTROL.BSAVE' THEN
commit_form;
clear_form(no_validate);
ELSIF name_in(':SYSTEM.TRIGGER_ITEM')='CONTROL.BEXIT' THEN
exit_form(no_validate);
ELSIF name_in(':SYSTEM.TRIGGER_ITEM')='CONTROL.BCLEAR' THEN
clear_form(no_validate);
ELSIF name_in(':SYSTEM.TRIGGER_ITEM')='CONTROL.BQUERY' THEN
execute_query;
ELSIF name_in(':SYSTEM.TRIGGER_ITEM')='CONTROL.BDELETE' THEN
delete_record;
commit_form;
ELSIF name_in(':SYSTEM.TRIGGER_ITEM')='CONTROL.PREVIOUS' THEN
previous_record;
ELSIF name_in(':SYSTEM.TRIGGER_ITEM')='CONTROL.NEXT' THEN
next_record;
END IF;
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