Re: SQL*Plus output formatting question
Date: 25 May 2002 23:23:16 -0700
Message-ID: <6f53f9c1.0205252223.ee06b50_at_posting.google.com>
vk02720_at_my-deja.com (vk02720) wrote in message news:<4d814faa.0205240611.10c1260f_at_posting.google.com>...
> happytechie <member_at_dbforums.com> wrote in message news:<3cedda81$3_at_usenetgateway.com>...
> > use the lpad and rpad functions to achieve the desired field width.
> >
> > PT
>
> Wouldnt the use of lpad and rpad afect the performance ? Are there any
> SQL*Plus 'set' options which would have the same effect ?
> In fact lpad and rpad may trim the blanks from the data and not the
> spaces that are between the columns(data) output by SQL*Plus.
You can format the columns prior to running the query without using the lpad or rpad. For instance if you wanted to format the owner column to be 20 bytes
SQL> col owner for a20
SQL> select owner from ....
Received on Sun May 26 2002 - 08:23:16 CEST