SQL*Plus (MOSC)

MOSC Banner

Email SQL*Plus output as HTML

edited Apr 13, 2016 5:04AM in SQL*Plus (MOSC) 1 commentAnswered

Hi, i'd like to email my SQL*Plus query output as HTML. I was able to make it email the output but its all in plain text.

here is my simple shell script below:

#!/bin/ksh

FROM="migs.isip.23@gmail.com"
TO="migs.isip.23@gmail.com"
SUBJECT"=This email has html contents"
CONTENTS="/home/mail_text.html"
HEADER="From: ${FROM} \nTo: ${TO} \nSubject:${SUBJECT} \nContent-Type: text/html; charset=us-ascii \nContent-Transfer-Encoding: 7bit \nMIME-Version: 1.0"

sqlplus -s apps/dfw_lower <<END_OF_SQL

SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON -
HEAD "<TITLE>Department Report</TITLE> -
<STYLE type='text/css'> -
<!-- BODY {background: #FFFFC6} --> -
</STYLE>" -
BODY "TEXT='#FF00Ff'" -
TABLE "WIDTH='90%' BORDER='5'"

COLUMN DEPARTMENT_NAME HEADING 'Invoice Number' ENTMAP OFF
COLUMN CITY HEADING 'Invoice Date'

SPOOL $
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center