Re: SQL*Plus report formatting

I tried the TO_NUMBER as described, but cannot get it to work properly. Here is a brief view of my select statement, maybe you can correct my error.

SELECT P.CUSTOMER_REF,P.JOB_MANAGER_REF, P.PROJECT_NO, TO_NUMBER(P.JOB_NO, '99'), P.DES1, P.EST_COMPLETION_DATE, P.DEADLINE_DATE, P.UD_NOTE FROM K.PA_JOB What am I doing wrong? If this enough info to tell?

The word wrap issue deal with my Descripiton field. It is 2000 charaters long , but on the report it is only 31 character wide. I want to make sure the lines wrap at least on a per word basis. You are prbably right with the word_wrapped command. I will attempt to find it in my books. Do you know of a good source for these commands? I have three different books I look through now and still can't seem to find some of these answers.

Thanks
Jon

"Matt B." <gtimatt_at_home.com> wrote in message news:itLl7.93518$MC1.30260776_at_news1.elcjn1.sdca.home.com...
> "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?
>
> 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 - 09:40:58 CDT