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!

Split String for every n characters and add space

hsemarApr 6 2017 — edited Apr 6 2017

Hi,

Need the select Query  to split the string and add space for every n characters.   For e.g,

If the string contains

abcdefghijklmnopqrstuvwxyz

The output should be

abcde fghij klmno pqrst uvwxy  z

for every 5 characters i have added a space.

Regards,

Ramesh G
This post has been answered by Frank Kulash on Apr 6 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 4 2017
Added on Apr 6 2017
#sql
4 comments
4,246 views