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 a string into an collection - output modified

Raghavendra Setty-OracleMar 31 2016 — edited Apr 4 2016

Hi Cheers,

DB version: Oracle 11g;

Apologies.. I have already raised similar kind of requirement, Output format has been modified.

Could you please help to convert below format. Thanks in advance.

Input: 1210~011000~~~yep~

Output: a(1) => 1210

a(2) => 01100

a(3) => null

a(4) => null

a(5) => yep

Regards,

Thank You.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 2 2016

Added on Mar 31 2016

21 comments

3,848 views