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!

Remove Leading zeros from column

822690Dec 9 2010 — edited Dec 9 2010
How can I remove leading zeros from a column?

The data looks like *00-04-071*

The output should display 4071
This post has been answered by Solomon Yakobson on Dec 9 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 6 2011
Added on Dec 9 2010
3 comments
24,318 views