SQL> SELECT LEVEL, REGEXP_SUBSTR('RAJIB NARSINGDI DHAKA BANGLADESH','[^ ]+', 1, LEVEL) FROM DUAL
CONNECT BY REGEXP_SUBSTR('RAJIB NARSINGDI DHAKA BANGLADESH', '[^ ]+', 1, LEVEL) IS NOT NULL; 2
LEVEL REGEXP_SUBSTR('RAJIBNARSINGDIDHA
---------- --------------------------------
1 RAJIB
2 NARSINGDI
3 DHAKA
4 BANGLADESH
SQL> SELECT ROWNUM SL, EXTRACTVALUE(XT.COLUMN_VALUE, 'e') COLUMN_VALUES
2 FROM TABLE(XMLSEQUENCE(EXTRACT(XMLTYPE('<coll><e>' ||
3 REPLACE(REPLACE(REPLACE('RAJIB NARSINGDI DHAKA BANGLADESH','&',''),':',''),
4 ' ',
5 '</e><e>') ||
6 '</e></coll>'),
7 '/coll/e'))) XT;
SL COLUMN_VALUES
---------- --------------------------------
1 RAJIB
2 NARSINGDI
3 DHAKA
4 BANGLADESH
SQL>
CONNECT BY REGEXP_SUBSTR('RAJIB NARSINGDI DHAKA BANGLADESH', '[^ ]+', 1, LEVEL) IS NOT NULL; 2
LEVEL REGEXP_SUBSTR('RAJIBNARSINGDIDHA
---------- --------------------------------
1 RAJIB
2 NARSINGDI
3 DHAKA
4 BANGLADESH
SQL> SELECT ROWNUM SL, EXTRACTVALUE(XT.COLUMN_VALUE, 'e') COLUMN_VALUES
2 FROM TABLE(XMLSEQUENCE(EXTRACT(XMLTYPE('<coll><e>' ||
3 REPLACE(REPLACE(REPLACE('RAJIB NARSINGDI DHAKA BANGLADESH','&',''),':',''),
4 ' ',
5 '</e><e>') ||
6 '</e></coll>'),
7 '/coll/e'))) XT;
SL COLUMN_VALUES
---------- --------------------------------
1 RAJIB
2 NARSINGDI
3 DHAKA
4 BANGLADESH
SQL>