Set Markup Html On Entmap Off Spool On Preformat Off Set Term Off Spool ColorTest.Html Select '<Font Color="LightSeaGreen">'|| EmpNo ||'</Font>' As Empno , '<Font Color="DarkRed">' || EName ||'</Font>' As EName , '<Font Color="Magenta">' || Hiredate ||'</Font>' As Hiredate From Emp Where Deptno = 20; Spool Off Set Markup Html Off Entmap Off Spool Off Preformat Off Set Term On
It will generate the HTML report shown below.
No comments:
Post a Comment