Re: padding zero before decimal if result is less than 1
- From: David Fitzjarrell <oratune@xxxxxxxxx>
- To: "ax.mount@xxxxxxxxx" <ax.mount@xxxxxxxxx>, Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 17 Oct 2011 09:33:16 -0700 (PDT)
SQL> column result format 999990.90
SQL>
SQL> select 1/2 result from dual;
RESULT
----------
0.50
SQL>
David Fitzjarrell
From: amonte <ax.mount@xxxxxxxxx>
To: Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, October 17, 2011 9:12 AM
Subject: padding zero before decimal if result is less than 1
Hi
In sqlplus when we divide if the result is less than 1, for example 0.5 we
see this:
SQL> select 1 /2 from dual;
1/2
----------
.5
Is it possible to get 0.5 without using to_char()?
I am fine with .5 but since this has to be written to an xls excel doesnt
like it!
Thank you
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
