SQL & PL/SQL

Hi folks,

this might be an easy question.

How can I split a concatenated string into multiple rows using SQL query?

INPUT:

select 'AAA,BBB,CC,DDDD' as data from dual

Delimiter = ','

Expected output:

data
------------
AAA
BBB
CCC
DDDD

I'm looking for something kind of "an opposite for 'sys_connect_by_path'" function.

Thanks,
Tomas