Generating HTML Reports from SQL*Plus

| Last Updated: | In: Mysql, Oracle


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 –

Enter a SQL query:

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:

oracle-reports

Tags: , , , ,


About: Prem Tiwari

Prem Tiwari is the founder of freewebmentor.com and is a professional developer who has vast experience in PHP and open source technologies. Apart from this, he is a blogger by hobby.


You may also like:

Follow us!

Get Free Access of 400+ Scripts

Don't worry you'll not be spammed!

Featured eBook

WordPress Security Guide

Free Guide: Learn how to implement security guideline in your WordPress site...

DOWNLOAD

Pincode Finder

pincode-finder tool

Online Pincode Finder

Best tool to locate post Office address and pincodes of all india...

SEARCH NOW