Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Leading 0 for float numbers between 0 and 1
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
Received on Thu Feb 23 2006 - 04:59:04 CST