I want to display my unix script mail in html style with a head,
I try
SET HEADING OFF
SET TRIMOUT OFF
SET SERVEROUTPUT OFF
SET ECHO OFF
SET FEEDBACK ON
SET PAGESIZE 0
SET LINESIZE 1990
set markup html on spool on
SPOOL my_report.csv
COLUMN ID FORMAT A4
COLUMN ACTIONID FORMAT A10
COLUMN STATUS FORMAT A6
PROMPT em_id,action_id, error
select * from test1 where STATUS='ERROR';
set markup html off spool off
exit;
I get the html table source code display on my mail
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="generator" content="SQL*Plus 11.1.0">
<style type='text/css'> body {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} p {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} table,tr,td {font:10pt Arial,Helvetica,sans-serif; color:Black; background:#f7f7e7; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px;} th {font:bold 10pt Arial,Helvetica,sans-serif; color:#336699; background:#cccc99; padding:0px 0px 0px 0px;} h1 {font:16pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; border-bottom:1px solid #cccc99; margin-top:0pt; margin-bottom:0pt; padding:0px 0px 0px 0px;-
} h2 {font:bold 10pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; margin-top:4pt; margin-bottom:0pt;} a {font:9pt Arial,Helvetica,sans-serif; color:#663300; background:#ffffff; margin-top:0pt; margin-bottom:0pt; vertical-align:top;}</style><title>SQL*Plus Report</title>
</head>
<body>
<table border='1' width='90%' align='center' summary='Script output'>
<tr>
<td>12345</td> <td>Delete </td><td>Error</td>
..........
Thank you