Wednesday, March 22, 2017

Message for check join date



begin
if :join_dt <=sysdate then
    message('Check Join Date!!');
else
    message('Join date must be less then or equal Current date!!');
    message('Join date must be less then or equal Current date!!');
    raise form_trigger_failure;
   
end if;
end;

No comments:

Post a Comment

 https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/