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!

Query with substr

user12863665Mar 21 2017 — edited Mar 22 2017

Hi,

i am getting data like below from one column.anyone suggest me how can i write substr query in oracle database?

*Just for example purpose, i presented below values and those values dynamically change.

ABC

ABC,XYZ

ABC,XYZ,EFG

based on above data, all ABC should be in one column,XYZ in another column and EFG in another column

anyone suggest me how can i achieve this with substr function.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 19 2017
Added on Mar 21 2017
2 comments
346 views