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!

convert string data to columns

ShivanshuJun 29 2016 — edited Jun 29 2016

can somebody help me on the issue where i have data like :

#1#5#3#2#5#7
#5#3#5#4#3#2
#1#7#5#3#6
#3#5#2#1#5
#6#5#4#7#1#2

and i need to each numberic should be columns wise like this

    

COL_ACOL_BCOL_CCOL_DCOL_ECOL_F
153257
535432
17536
35215
654712

Thanks,

Shivanshu

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 27 2016
Added on Jun 29 2016
6 comments
1,484 views