I've got a table in database which consists of start date and finish date. Ok now what I have to do is the fact that database ought to be checked once during the night checking all finish dates. if today is yesterday the finish date, i quickly can perform java class which will send the e-mail notification saying membership will expire. I'm using oracle database and java (jsf) as development language.

My date saved within the table is within my preferred format i.e. MM/DD/YYYY.


Schedule a job using DBMS_SCHEDULER to operate a PL/SQL procedure in an interval you would like. The PL/SQL process could then call your java method to transmit the e-mail notification.