hay guys how would i send and email lets say as an reminder based on the conditions of a report
I have a table which looks like this
ASSESSMENTS_DONE
USER_ID forms_to_fill Forms_done outstanding
------------------------------------------------------------------------------------------------------------------------
user@1 5 5 0
user@3 4 3 1
user@5 9 7 2
So I am thinking i would have to set a conditional pl/sql expression on Ouststanding column because this the column i want to reference which will have the logic in it the looked something like this (where 'outstanding' >0 send email )
In administration under users I have user@3 stored as USER@3 with his email stored as UsEr@3 which is his real email address . And user@5 would have the same set up around the storage of his name . The reason that I picked user@3 and user@5 is because they have outstanding forms to fill
what i would like to know is how would the syntax for sending this email reminder look like being that there has to be a where clause in there . and will the email still go through to the users that are outstanding even if there is a difference in there user name and email because as you can see the user name and email are the same but the email has variance in upper and lower case
Please advise
Thank you