Sql query

[billiauk]

Just for fun, try this (requires 9i, tested in 9.2.0.1):

SELECT str, EXTRACTVALUE(xt.column_value,'e') AS name
FROM   t
     , TABLE(XMLSEQUENCE
       ( EXTRACT
         ( XMLTYPE('<coll><e>' ||
                   REPLACE(t.str,',','</e><e>') ||
                   '</e></coll>')
	 , '/coll/e') )) xt;

Brilliant !!!