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: fumi <fumi_at_tpts5.seed.net.tw>
Date: Mon, 2 Apr 2001 23:07:31 +0800
Message-ID: <9aa5i1$oh1$3@news.seed.net.tw> 







<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 Mon Apr 02 2001 - 10:07:31 CDT












Original text of this message













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