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!

SQL Query to split each character in a string into rows in oracle 10g

3155199Mar 17 2016 — edited Mar 17 2016

Hi ,

Please give me SQL Query to split each character in a string into rows in oracle 10g

For ex. suppose my string is "00001100"

Output like :

0

0

0

0

1

1

0

0

Please let us know ASAP

This post has been answered by Nimish Garg on Mar 17 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 14 2016
Added on Mar 17 2016
7 comments
866 views