> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
