padding zero before decimal if result is less than 1

From: amonte <ax.mount_at_gmail.com>
Date: Mon, 17 Oct 2011 18:12:12 +0200
Message-ID: <CABV7K9tecQotHPo_H3A75-soYX0Ed3cpzFv1hO9CX5Z+--LJcg_at_mail.gmail.com>

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

--

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