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!

Pivoting string values( ,comma seperator) to separate columns(usingREG_EXP)

NarenApr 9 2010 — edited Apr 9 2010

<pre>
I have column PART which contains string as shown below

PART
----------
BMW PART,TEST PART,TEST PART,HYPER PART,HYPER PART,TESTINGNEWONE,TESTINGNEWONE,TESTINGNEWONE

string has got comma separated, i need to project as individual columns like

P1 P2 .... P8
_________ __________ ____________
BMW PART TEST PART TESTINGEWONE

how can it be done... (i think by using regular expressions it can be done but i am not aware of it can any one help)

</pre>

Thanks
Naren

Locked Post

New comments cannot be posted to this locked post.

Locked on May 7 2010

Added on Apr 9 2010

5 comments

1,280 views