Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to send an e mail based on a value?

Gui Rocha-OracleMay 20 2015 — edited May 20 2015

Hi everyone,

I`m really new in the APEX system, and coding, so i might need more help then it looks.

What i want to do is send an email to someone one month before a especific date set in a column.

What i thought to do is to create a new column with the value:  sysdate - Date_in_the_column.

Now what i don t know how to is how to check this to send an email when my new column value is =30. Do i create a job or a process (i need to constatly check this value right, to know when to send the email)? if so how do i do this?

Thank you in advance
This post has been answered by Jitendra on May 20 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 17 2015
Added on May 20 2015
#apex-discussions, #email, #job, #process, #trigger
2 comments
678 views