You will probaby end up using a PL/SQL loop with the functions INSTR http://technet.oracle.com/docs/produ...tion.htm#77600 and SUBSTR http://technet.oracle.com/docs/produ...tion.htm#87096