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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Forcing 2 Decimal Positions

Re: Forcing 2 Decimal Positions

From: Stephane Faroult <sfaroult_at_oriole.com>
Date: Wed, 12 Mar 2003 12:04:08 -0800
Message-ID: <F001.005680D9.20030312120408@fatcity.com>


> Jacques Kilchoer wrote:
>
> Or if your question was relating to the COLUMN ... FORMAT SQL*Plus
> command, 99 works for me (again my decimal separator is "," because of
> local settings) using SQL*Plus 8.1.7
>
> SQL> column price format 90D99
> SQL> select 20 as price from dual
> 2 union all
> 3 select 20 / 3 as price from dual
> 4 union all
> 5 select 20 / 8 as price from dual
> 6 union all
> 7 select 20 / 16 as price from dual
> 8 union all
> 9 select 20 / 32 as price from dual ;
>
> PRICE
> ------
> 20,00
> 6,67
> 2,50
> 1,25
> 0,63

NLS_LANGUAGE='FREEDOM' :-).

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Mar 12 2003 - 14:04:08 CST

Original text of this message

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