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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
646 views