i want to spool a file and print it. can i set the font name and size how to do it
It would be nice if you could set the font but unfortunately it will only create a pure text file, so the only way could get around it is to bring it into a text editor.
Another option : if your version of sql*plus supports, use the HTML-generating with spool. Check the SET MARKUP HTML commands in the sql*plus manuals.
What version is SET MARKUP in?
OH, OK, version 9.0.1. How cool is that?
Jeff, the MARKUP facility was built in in SQL*PLUS for the 8i versions (I´m using 8iR3 here, but AFAIK it was available in R2, too.
The output is ** VERY ** simple, basically it will generate a table using td markup commands. Surely, to more sofisticated formatting (as font size, etc) you WILL need to add extra format lines in the resulting spool file.
My tests (inside sql*plus) :
SQL>set markup html on
SQL> select * from dept;
SQL>set markup html off
The generated file is :
hmmm, I'm using 8.1.7 too. I'll do more research...
Cool! I like that! Im off to amaze my friends with that one :-)
SQL> spool d:\new.html
SQL> set markup html on
unknown SET option "markup"
I m using 8.1.5, how I set the markup html ?
I had tried as you told.. I got the following error..
Can u please let me clear this doubt?
SQL> Spool c:\test.html
SQL> SET HTML MARKUP ON
What i have to give ?
I am using 8.1.6 ver ...
Palani Kumar. R
[Edited by kumar_rp on 08-31-2001 at 02:57 AM]
You Can Win, if u believe Yourself
Click Here to Expand Forum to Full Width