SQL ORACLE: Trasformare stringa in tabella

SELECT Replace(CAMPO,'''','') CAMPO FROM ( SELECT * FROM dual PIVOT ( COUNT(*) FOR (DUMMY) IN ( 'CNR1','321G','321H','321I' ))) mytab UNPIVOT INCLUDE NULLS ( VAL FOR( CAMPO ) IN ( "'CNR1'","'321G'","'321H'","'321I'" ) );