Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Spacing between columns in SQL*Plus

Re: Spacing between columns in SQL*Plus

From: Mike S. <no email>
Date: Tue, 03 Apr 2001 01:12:57 -0700
Message-ID: <o71jctcvgj3pvoacrsvlfqci7hk5ugboh1@4ax.com>

You're right. I was mixing up SQL*PLUS column formats with TO_CHAR() format models. This does work:

set colsep ''

select table_name,
 lpad(to_char(blocks, 'FM999999'), 6) || lpad(to_char(empty_blocks, 'FM99999'), 5)
from user_tables
order by table_name;

I've tested it with Oracle 8.04 Personal Edition for Windows 95.

On Mon, 2 Apr 2001 23:07:31 +0800, "fumi" <fumi_at_tpts5.seed.net.tw> wrote:

>
><Mike S.> ????? news:ipm8cto53ap5dki1ebpeuuuf6v8qdq88lu_at_4ax.com...
>> On 30 Mar 2001 00:26:46 GMT, bdahms_at_geoprocessing.com wrote:
>>
>> A column command with "FM" in the format model should do it:
>>
>> COLUMN somenumber FORMAT FM9,990.00
>>
>> Mike S.
>
>
>Do *NOT* use the "fm" format in the options of COLUMN in SQL*Plus.
>It's undocumented, and it would cause a erroneous display.
>
>
Received on Tue Apr 03 2001 - 03:12:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US