Oracle Forms || Post-Query & Pre-Query Triggers || Bangla (23)
Oracle Forms || Post-Query & Pre-Query Triggers || Bangla (23)
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 POST-QUERY & PRE-QUERY Trigger.
I have giving example code here.
POST-QUERY:
SELECT DEPARTMENT_NAME INTO :EMPLOYEES.DEPT_NAME FROM DEPARTMENTS
WHERE DEPARTMENT_ID=:EMPLOYEES.DEPARTMENT_ID;
PRE-QUERY:
IF :EMPLOYEES.COMMISSION_PCT IS NULL AND :EMPLOYEES.MANAGER_ID IS NULL THEN
MESSAGE('YOU MUST QUERY BY COMMISSION AND MANAGER ID.');
MESSAGE('YOU MUST QUERY BY COMMISSION AND MANAGER ID.');
RAISE FORM_TRIGGER_FAILURE;
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