SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

'SET MARKUP HTML' top left alignment in SQL*Plus

624226Jul 7 2010 — edited Jul 7 2010

I have a SQL script which generates HTML that is then emailed as a HTML email. I am using the following SET Markup command

SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON -
HEAD "<STYLE type='text/css'> -
table,tr,td { -
font:10pt Arial,Helvetica,sans-serif; -
text-align:left; -
vertical-align:top; -
color:black; background:white; } -
 -
</STYLE>" -
BODY "TEXT='black'" -
TABLE "WIDTH='100%' BORDER='1'"

Looking at the file generated it is creating the table tags OK but there is no CSS. This means the text is vertical aligned in the centre of the cell and I want it top left.

Any ideas?
Ben

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 4 2010

Added on Jul 7 2010

#css, #email, #html

2 comments

2,384 views