decode result

[ang90]

Hello,

I want to see '000.00' in a decode result. Can someone tell how to print it? I can print
999.99 but not 000.00. Its converting into 0.

 

[BJCooperIT]

Apply a format mask.

SQL> select decode(dummy,'X',0,1) result from dual;

    RESULT
----------
         0

SQL> select to_char(decode(dummy,'X',0,1),'099.99')  result from dual;

RESULT
-------
 000.00

SQL>

^{Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw}
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
Author and Sole Proprietor of: Emu Products Plus