For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi All, I want to convert comma-separated rows to columns.
WITH rws AS ( SELECT ' , 2, 3' c1 FROM dual UNION ALL SELECT '1, , 3' c1 FROM dual ) SELECT * FROM rws; C1 C2 C3 2 3 1 3