Oracle Apex custom Expiry message by date

Dynamic True Action on Page Load of Home Page 1:

Action 1 : PLSQL :

select TO_CHAR(EXPIRY_DATE,'DD-MON-RRRR') into :P1_EXPIRY_DATE
from ORGANIZATION WHERE ID=1001;

Action 2 : Javascript :

var expdt = $v("P1_EXPIRY_DATE");
apex.message.alert("Your Application will expire on "+expdt);



Muhammad Abdullah Al Noor

Muhammad Abdullah Al Noor, An Oracle Apex Consultants and founder of Noors Technology (www.noorstech.com). Core Expertise : Database Administration, Oracle Forms and Reports Development, Oracle Apex Application Designer and Development, Linux Professional etc. Also the owner of TrainerBD Training and OraDemy E-Learning. WhatsApp +8801790721177

Post a Comment

Previous Post Next Post