How to convert comma separated values into rows in pl sql

 WITH data AS (
    SELECT
        :values1 str
    FROM
        dual
)
SELECT
    TRIM(regexp_substr(str, '[^,]+', 1, level)) str
FROM
    data
CONNECT BY
    instr(str, ',', 1, level - 1) > 0;

WITH data AS (

    SELECT

        subject str

    FROM

        dly_rpt_tbl

    WHERE

        id ='1251912748426776107'

)

SELECT

    TRIM(regexp_replace(regexp_substr(str, '[^,]+', 1, level), '[^[:digit:]]', ''))                column1

FROM

    data

CONNECT BY

    instr(str, ',', 1, level - 1) > 0;