Oracle Converting delimited string to column

WITH
test AS
( select
column_value AS c1
FROM
TABLE( SYS.DBMS_DEBUG_VC2COLL( 'CAT','DOG','MOUSE' , 'RAT' , 'BAT' , 'CAR' , 'DOOR' , 'LOCK') )
)
SELECT * FROM test ;



Output will like following

C1
CAT
DOG
MOUSE
RAT
BAT
CAR
DOOR
LOCK