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

Home -> Community -> Usenet -> c.d.o.misc -> Re: number format (.5 instead of 0.5)

Re: number format (.5 instead of 0.5)

From: Tino Korth <newsgroup_at_tk79.de>
Date: Tue, 24 Sep 2002 11:44:25 +0200
Message-ID: <ampc5g$a68$1@nntp-m01.news.aol.com> 





Hello,



> maybe with is you're looking for:

> select to_char(0.5,'0D0') from dual




that's it! :o)



Is is possible to set that format session-wide (ALTER SESSION SET ...)?




Greetings from Rostock, Germany!



Tino


-- 
Tino Korth                               Registered Linux User #286417
www.tinokorth.de - ICQ 10771191                  http://counter.li.org


Received on Tue Sep 24 2002 - 04:44:25 CDT












Original text of this message













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