Generating HTML Reports from SQL*Plus

This post explains how to generate a HTML reports from your Sql *plus query results. You can produce HTML output in AN interactive SQL*Plus session victimization the SET MARKUP command. you\’ll be able to embrace AN embedded sheet, or the other valid text within the HTML tag.

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'"

HEAD "<TITLE>Department Report</TITLE> -

<STYLE type='text/css'> -

-

</STYLE>" -

BODY "TEXT='#FF00Ff'" -

TABLE "WIDTH='90%' BORDER='5'"

Enter a SQL query:

SELECT '<A HREF="http://oracle.com/'||DEPARTMENT_NAME||'.html">'||DEPARTMENT_NAME||'</A>' DEPARTMENT_NAME, CITY
FROM EMP_DETAILS_VIEW
WHERE SALARY>12000;

SELECT '<A HREF="http://oracle.com/'||DEPARTMENT_NAME||'.html">'||DEPARTMENT_NAME||'</A>' DEPARTMENT_NAME, CITY

FROM EMP_DETAILS_VIEW

WHERE SALARY>12000;

Enter the SPOOL OFF command:

SPOOL OFF

The and tags area unit appended to the spool file, report.html, before it’s closed.

The output from report.sql may be a file, report.html, which will be loaded into an online browser. Open report.html in your application program. It ought to seem one thing just like the following:

If you like FreeWebMentor and you would like to contribute, you can write an article and mail your article to [email protected] Your article will appear on the FreeWebMentor main page and help other developers.

Generating HTML Reports from SQL*Plus

Enter a SQL query:

Enter the SPOOL OFF command:

Recommended Posts:

webmentor