Oracle SQL

Nice tutorial

http://www.tek-tips.com/viewthread.cfm?qid=1629662

We had a scenario , where we broke a master table CLOB column , into multiple rows in child tables VARCHAR2.
Functions LISTAGG and XMLAGG didn't help us , we keep getting 'concatinated string too large' error.... the above link helped us