PL/SQL Script to send a mail with the details

 Hi ,

I have a table called Training_details.The columns are as follows.

[code]

Empno,Ename,Emp_Mail,Gender,Course_Num,Course_Name,Start_Date,End_Date,Duration,

Training_type(Online/Classroom), Target_time,Training_Status,Supervisor_name,Supervsor_Mail_Id

[/code]

Condition:  1. if training_type is online then target_time=sysdate+1 month

                    2. if training_type is classroom then target_time=sysdate+2 months

we need to give Online/Mandatory as LOV to Training_type (am not ware how to give it in PL/SQL)

after filling the data need to send a mail to supervisor and CC to the related Employee as follows .It should be system generated mail only.