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!

Parse tab separated string

M.EmmanuelJun 12 2016 — edited Jun 13 2016

Hi,

In Oracle 11g XE and given:

v_string VARCHAR2(1000) := 'foo1    foo2    foo3    bar1';

where foo1 foo2 foo3 and bar1 are separated by tabs.

How could I extract individually foo1, foo2, foo3 and bar1 and iterate over them? How do I parse the varchar2 to get tab separated values?

Thanks,
This post has been answered by Frank Kulash on Jun 12 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2016
Added on Jun 12 2016
5 comments
1,431 views