-
i want to spool a file and print it. can i set the font name and size how to do it
Thanks
-
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.
[]s
Chiappa
-
What version is SET MARKUP in?
Jeff Hunter
-
OH, OK, version 9.0.1. How cool is that?
Jeff Hunter
-
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>SPOOL C:\EXIT.HTML
SQL>set markup html on
SQL> select * from dept;
........
SQL>set markup html off
The generated file is :
DEPTNO
|
DNAME
|
LOC
|
---|
10
|
ACCOUNTING
|
NEW YORK
|
20
|
RESEARCH
|
DALLAS
|
30
|
SALES
|
CHICAGO
|
40
|
OPERATIONS
|
BOSTON
|
-
hmmm, I'm using 8.1.7 too. I'll do more research...
Jeff Hunter
-
tried it...
Cool! I like that! Im off to amaze my friends with that one :-)
-
Hi
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 ?
Thanx
-
HTML_MARKUP
Hi Guys,
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
SQL>:(SQL>)
What i have to give ?
I am using 8.1.6 ver ...
Thanx...
Palani Kumar. R
[Edited by kumar_rp on 08-31-2001 at 02:57 AM]
RP Kumar
You Can Win, if u believe Yourself
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|