Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

retain trailing zero's after decimal

576856Jun 15 2009 — edited Jun 15 2009
Hi,

i have a requirement to retain trailing zero's after decimal....

is it possible?

version: 9.2.0.7

example: select 150.200 from dual;
we will get 150.2 as output.

but i need 150.200 as the output...

how would i do this?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2009
Added on Jun 15 2009
7 comments
1,745 views