Re: Form Feed in SQL*Plus

In article <1992May15.080023.6573_at_syma.sussex.ac.uk> lezo_at_syma.sussex.ac.uk (Lez Oxley) writes: dtrum_at_jetssrg.af.mil (David Trum x4772) writes:
:
: To put a form feed in SQL*Plus, I add the following line BEFORE
: my select:
:
: ttitle left '^L'
:
: The control-L is a form feed and works on my SCO unix systems and
: Suns talking to HP and postscript printers (using a ps translator).
:

Is this an actual <FF> ie. Octal 014 or a caret + L?

Also, Is this the way you can embed <ESCAPE> sequences to, for example, set the laser printer into condensed or landscape mode? If not how can you send <escape> sequences from SQL*PLUS to set up the printer in the mode that you want?

You can also use the CHR() function to send escape sequences, as in SELECT CHR(12) || CHR(100) || CHR(Whatever)... from dual;

If you use the SET HEADING OFF, SET FEED OFF, SET PAGES 0, and other such formatting commands in a SQL*Plus script, the effect is you'll just get the escape sequence, then use a second SQL statement(s) to generate your data.

You can also use CHR() In reportwriter if you don't like to mess around with PRINTDEF, as I don't.

I think we've finally got the Oracle Newsfeed working reliably now, so hopefully those of us at Oracle who follow news (lots of us actually) can start giving the user community more help via posting instead of just by email. If there is any information you'ld like to see posted by Oracle (new product announcements, support bulletins, technical tips, etc,) please let us know. If you'ld like us to keep quiet, we can sure do that too.

Take Care,

• Dan

Daniel Druker
Senior Consultant
Oracle Corporation                    

| Dan Druker                    |  work 415.541.5530     fax  415.541.0283    |
| oracle*mail ddruker.us1       |  internet: ddruker_at_us.oracle.com            |
-------------------------------------------------------------------------------

Disclaimer: These are my opinions and mine alone, and don't reflect the views or position of my employer. Received on Sun May 17 1992 - 10:25:07 CEST