I am using Oracle 11.2.0.3. I need fastest way to split organization names base on space possible just using SQL.
with org as
(
select 1 org_pk , 'ALL american ,INC' org_nm from dual union all
select 2 org_pk , 'A.G COMPANY' org_nm from dual union all
select 3 org_pk, 'GROWTH FUND SPONSORS and SONS, INC.' org_nm from dual
)
select * from org ;
Result I need is
1 ALL
1 american
1 ,INC
2 A.G
2 COMPANY
3 GROWTH
3 FUND
3 SPONSORS
3 and
3 SONS,
3 INC.
Many thanks.