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!

trailing zero disappear

user11219778Mar 16 2011 — edited Mar 16 2011
Hi,

My trailing zero is disappearing after loop through a set of values and then selecting it form Dual table,

I have already tried to_char , to_char(to_number and regular expressoin.

my column DT is varchar2

any help is appreciated.

!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 13 2011
Added on Mar 16 2011
5 comments
768 views