Currency field with 2 decimal

[dhanashri]

I need to display the data in the currency field up to 2 decimal point.
example if the fetch from data base is
option 1: 12.547 want to display 12.55
option 2: 12 want to display 12.00
option 3: 12.5 want to display 12.50
is there is any way I can use any oracle function and make my sql query result look like this. I will really appreciate help.

[debasisdas]

use in this format
[code=oracle]select to_char(round(1 2.5,2),'9999999 9.99') from dual[/code]

[amitpatel66]

I need to display the data in the currency field up to 2 decimal point.
example if the fetch from data base is
option 1: 12.547 want to display 12.55
option 2: 12 want to display 12.00
option 3: 12.5 want to display 12.50
is there is any way I can use any oracle function and make my sql query result look like this. I will really appreciate help.

Hi Dhanashri,

Welcome to TSDN!!
Please make sure you follow POSTING GUIDELINES when ever you post in this forum

Thanks
MODERATOR