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