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!

Adding leading zero in comma separated string

bridledNov 9 2015 — edited Nov 9 2015

Dear all

Currently i am working on Oracle 11g

I have string like 1,12,123,1234 and my requirement is to fill the leading zero on each comma separated string

My Output result should be like this 0001,0012,0123,1234 what exactly lpad('12',4,'0') is doing.

Kindly assists an above query.
This post has been answered by Karthick2003 on Nov 9 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 7 2015
Added on Nov 9 2015
#sql
3 comments
635 views