On the move:

I'm currently moving the following to their own blogs: Unix, HTML for Blogs, Perl & Java.
The links are on the left side.

Friday, May 23, 2008

HTML Output


If you want to view the HTML code generated, use Notepad, not Word. The spool file can have the following extensions: HTM, DOC or XLS. The prompt at the end is just to remind folks where to find the report generated.

SET MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF
SET TERM OFF

SPOOL EMP.HTM


Select *

from EMP;

SPOOL OFF

SET MARKUP HTML OFF ENTMAP OFF SPOOL OFF PREFORMAT OFF
SET TERM ON


PROMPT ** Report Completed. Use Mozilla to view your output: EMP.HTM **

No comments:

Post a Comment