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);
Tags:
Oracle Apex