Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Leading 0 for float numbers between 0 and 1
<falbrech_www_at_gmx.de> wrote in message
news:1140692344.571781.103900_at_p10g2000cwp.googlegroups.com...
: Hello,
:
: is there a way to retrieve floats between 0 and 1 with an 0 before the
: decimal point, e.g. .12 -> 0.12? But a value like 1234.34345 shold be
: displayed as is.
:
: Actually a solution which influcences any statements without changing
: them would be preferable (changing a session parameter for example).
:
: thanks in advance,
: Florian
:
data display is often entirely dependent on your tool/interface
you can you to_char, but then that changes the datatype
where are you displaying the numeric data (what tool, program, ui, etc.) where it needs this format?
++ mcs Received on Thu Feb 23 2006 - 06:56:24 CST