SQL snipets

Query to get comma separated values into each row

SELECT TRIM(regexp_substr(:l_comma_code,'[^,]+', 1, level)) Comma_col_value

                           FROM dual

                     CONNECT BY regexp_substr(:l_comma_code,'[^,]+', 1, level) is not null;