Re: SQL*Plus output formatting question
From: vk02720 <vk02720_at_my-deja.com>
Date: 24 May 2002 07:11:38 -0700
Message-ID: <4d814faa.0205240611.10c1260f_at_posting.google.com>
Date: 24 May 2002 07:11:38 -0700
Message-ID: <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. Received on Fri May 24 2002 - 16:11:38 CEST