DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: fonts in sqlplus

  1. #1
    Join Date
    Jun 2001
    Posts
    45
    i want to spool a file and print it. can i set the font name and size how to do it
    Thanks

  2. #2
    Join Date
    Oct 2000
    Posts
    90
    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.

  3. #3
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    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

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    What version is SET MARKUP in?
    Jeff Hunter

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    OH, OK, version 9.0.1. How cool is that?
    Jeff Hunter

  6. #6
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    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








  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    hmmm, I'm using 8.1.7 too. I'll do more research...
    Jeff Hunter

  8. #8

    tried it...

    Cool! I like that! Im off to amaze my friends with that one :-)

  9. #9
    Join Date
    Aug 2001
    Posts
    134

    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

  10. #10
    Join Date
    May 2001
    Location
    Dallas, US
    Posts
    78

    Question 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&gt:(SQL&gt)

    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
  •  


Click Here to Expand Forum to Full Width