split

[zarwar]

Otra alternativa más sencilla, aunque es para 11G:

with t as (
select 'sad,qq,rw,q' str from dual)
select trim (column_value) str
from t, xmltable(('"' || replace(str,',', '","') || '"'))
/

Un saludo