I need to setup an email trigger that sends mail every Wednesday.
I tried DAYOFWEEK() function used in reports but this function was not accepted in expression builder. I tried a workaround which required finding Mod of Julianday() but even Mod function wasn't accepted.
Can anyone please suggest a workaround for this ?
Thanks in advance!
You use bad choice of words.
TRIGGER is different from scheduled or periodic task.
use DBMS_SCHEDULER to accomplish goal.
How do I ask a question on the forums?
post full & complete results from SQL below
SELECT * FROM V$VERSION;