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!

INSTR & SUBSTR

RinneMay 14 2008 — edited May 15 2008
I have the following table:

columns: a, b;
values: 'val1', 'dfs, da, w4';
'val2', 'fbd, hsd, s, hgdf';

How can I write a query so that I return the following values?

values:
'val1', 'dfs';
'val1', 'da';
'val1','w4';
'val2', 'fbd';
'val2', 'hsd';
'val2', 's';
'val2', 'hgdf';
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 12 2008
Added on May 14 2008
8 comments
687 views