Skip to Main Content

SQL & PL/SQL

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!

Replace Function removing Zero from the end.

user2988171Jul 30 2010 — edited Jul 30 2010
Hi ALL,

I'm runing following query
select REPLACE(52000.50,'.') from dual
which is giving me output as

*520005*

But I need last zero also in the output. like *5200050*

Please help me if you have any solution.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2010
Added on Jul 30 2010
4 comments
795 views