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!

trimming leading zero

user12093849Mar 15 2010 — edited Mar 15 2010
I have table called test123
col1	col2
ABC	10,0000070,30
XYZ	59.9,0000000.1
I want to remove the leading zeros from the col2 values.

I run the following query to get the below o/p...and i did nt get the reqd. o/p
select to_char(trim(leading 0 from col2)) from test123
col1	col2
ABC	10,70,30
XYZ	59.9,0.1
Can you pls help me with this

Thanks in advance
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 12 2010
Added on Mar 15 2010
10 comments
22,560 views