Skip to Main Content
Forums

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!

Procedure or function to trim leading zeros

user545194Jun 21 2010 — edited Sep 3 2010
Hi!

I need to create a procedure or function that can trim the leading zeros of a value (character string).

I.e.

Original: 0000012345,67

Output: 12345,67

Thanks for any ideas/examples!

Edited by: user545194 on 21.06.2010 07:33
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2010
Added on Jun 21 2010
12 comments
4,769 views