I have a column named 'Commision'. It is defined as Number(10,2).
But actual values dont have any decimal points means they have values like 1400 11000 like this. ButI want to get the output as 11000.00 ,1400.00 and if it is null I have to get .00.
You would have to convert the number to a string in order to control the formatting in SQL (since the number 1400 and 1400.00 are identical as numbers). Something like
SELECT to_char( NVL( comission, 0 ), '9999999999.99' )
FROM dual
would probably do the trick.
I didn't like the taste of tongue and it didn't like the taste of me. I will now try this tiny ad:
a bit of art, as a gift, that will fit in a stocking