Output will send in mail

UNIX for Advanced & Expert Users
1

Hi All,
Requirement is to select the data from database and send the output in mail. But the output should in HTML tabular format in mail body.
For example my select command is :
select ename,esal,edegn,dept from emp where deptno in (10,15);
In the mail body the output should :

Employee Detail Report :-
EmployeeName EmployeeSalary EmployeeDesignation Department
Roxen 120000 MGR Fin
Alexander 220000 SrMGR Fin
Sombrero 320000 MGR Mkt
Elnor 520000 MGR RD

Please tell me the script.

Thanks
Alex

2

This looks like classwork.... we have a forum just for that.

Check this link for how to create html output in a sql script to a file:

Oracle HTML output

3

Want to write shell script and the database i m using is teradata.
Please suggest me the script.

Thanks
Alex

4

You may fare better on the Teradata website or through your support agency.

Data Appliance, Data Warehouse, Business Intelligence ?Teradata