Re: How to format NUMBER(8,4) to '0000.0000' output??

From: mRangel <marcus.rangel_at_gmail.com>
Date: 6 Sep 2006 16:20:43 -0700
Message-ID: <1157584843.470084.200950@i42g2000cwa.googlegroups.com>

Well, nvl(to_char(COLA, '0000.0000'),' ') does the trick. Why do you need the LPAD ?

system_at_TREINA01> create table besta ( numero number(8,4) );

Table created.

system_at_TREINA01> insert into besta values (1973.234);

1 row created.

system_at_TREINA01> select to_char(numero,'0000.0000') from besta;

TO_CHAR(NUMERO,'0000.0000')

---

 1973.2340 Received on Wed Sep 06 2006 - 18:20:43 CDT