Re: padding zero before decimal if result is less than 1

SQL> column result format 999990.90
SQL>
SQL> select 1/2 result from dual;

From: amonte <ax.mount_at_gmail.com>
To: Oracle-L Group <oracle-l_at_freelists.org> 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

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

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 17 2011 - 11:33:16 CDT