Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Spacing between columns in SQL*Plus
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
![]() |
![]() |