Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: number format (.5 instead of 0.5)
AFAIK, no. Oracle is just giving you something that is a number. You are
interested in how the number looks on the screen. Two different things. In
whatever, tool you are using you could write a format function.
Jim
"Tino Korth" <newsgroup_at_tk79.de> wrote in message
news:ampc5g$a68$1_at_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 - 09:20:52 CDT