Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Oracle

Posted Mar 7, 2003

Web Reports from SQL *Plus in Oracle 8i/9i - Page 2

By DatabaseJournal.com Staff

by Ajay Gursahani

A view source on "test.html" will typically display the following:

<html>
<head>
<title>
  SQL*Plus Report
</title>
<meta name="generator" content="SQL*Plus 9.0.1">
</head>
<body>

  SQL> select * from test;
<br>
<p>
<table border="1" width="90%">
<tr><th>
  UNIQUE_ID
</th><th>
  NAME
</th><th>
  SALARY
</th></tr>
<tr><td align="right">
  1
</td><td>
  ANDY
</td><td align="right">
  4500
</td></tr>
<tr><td align="right">
  2
</td><td>
  ALAN
</td>
<td align="right">
  3500
</td></tr>
<tr><td align="right">
  3
</td><td>
  JACK
</td><td align="right">
  3600
</td></tr>
<tr><td align="right">
  4
</td><td>
  PETER
</td><td align="right">
  4000
</td></tr>
<tr><td align="right">
  5
</td><td>
  JOE
</td><td align="right">
  2900
</td></tr>
</table>
<p>

  SQL> spool off
<br>
</body>
</html>

However, you can generate an HTML file by executing the following script from the OS level, which will suppress the SQL commands from spooling.

test.sql

SELECT * FROM test;
EXIT

SQL> sqlplus -s -m "HTML ON" wbur/wbur @c:\test.sql>test.html

"-m" uses HTML Markup Options. It allows you to start SQL *Plus session in 'markup mode', rather than using SET MARKUP command interactively (as we did in above example)

"-s" uses silent mode

 

The output is redirected to "test.html". A sample output of "test.html" is as below;

test.html

UNIQUE_ID

NAME

SALARY

1

ANDY

4500

2

ALAN

3500

3

JACK

3600

4

PETER

4000

5

JOE

2900

Note that the SQL commands are no longer displayed as part of html.

Summary

The above article gives a basic understanding of how we can generate HTML reports using the MARKUP option in SQL *Plus. You can extend this exercise by writing CGI scripts that will generate web reports.



Oracle Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM