Re: SQL Plus report problem
From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 8 May 1999 19:17:55 GMT
Message-ID: <7h22l3$gt2$1_at_nntp.csufresno.edu>
Date: 8 May 1999 19:17:55 GMT
Message-ID: <7h22l3$gt2$1_at_nntp.csufresno.edu>
In article <7gsjfp$88k$1_at_nnrp1.deja.com>,
<analyst_user_at_my-dejanews.com> wrote:
>I have a report that has 3 comment columns that are specified as length 10,10,
>and 10. In the table these fields have a length of 30,30,30.
>
>When the report is printed the comments are truncated and moved to the next
>line when they are more than 10.
>
>Is there a way to have just one column comments of length 30, and have the 2
>comments print under each other?
Try this:
Column COMMENTS format a30 wrapped
Select Rtrim(Rpad(Cmnt1,30)||Rpad(Cmnt2,30)||Cmnt3) COMMENTS
from My_Table;
Received on Sat May 08 1999 - 21:17:55 CEST