Re: SQL*Plus report formatting

[Quoted] "Jon Schlatter" <*jon-schlatter_at_stamats.com> wrote in message news:tpevq6lahf8d5b_at_corp.supernews.com...
> I am struggling through writing a report in SQL* Plus and have a few
> formatting questions.
>
> 1. Is it possible to suppress the statement of the number of lines at the
> end of a query? (xxxx rows selected)

set feedback off

> 2. How does the TO_NUMBER function work? I have a varchar2 field that
> acutally houses a number (not my db design) and need to convert it to a
> number so that it will sort properly. Is there another way to do
> this?

to_number(<value>).

Example:

to_number(002) will output 2

> 3. Can I control any of the page setup parameters of the spool file? It is
> defaulting to portrait and I need landscape.

set linesize <number of desired characters in a line>

It's probably defaulting to 79 or 80 now. Change it to 132 or whatever you like.

> 4. Is it possible to control the wrapping of text within a column?

[Quoted] In what way? (more info pls.) If it's what I'm thinking, look up the word_wrapped report formatting command.

-Matt Received on Thu Sep 06 2001 - 16:10:22 CEST