> 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
