Oracle line-to-row

such as SQL:

Select Zyxdm from table where bindid=2265254

The result of the query is: 1|4|8| 9|10

Turn this query result into multiple rows, and the result is as follows:

ID148910

SQL to convert:

With CTE1 as (select Zyxdm from table where bindid=2265254) Select Regexp_substr ((SELECT * from CTE1), ' [^|] + ', 1, ROWNUM) Idfrom DUAL CONNECT by ROWNUM <= Length ((SELECT * from CTE1) – Length (REPLACE ((SELECT * from CTE1), ' | ' , ")) + 1

　　

Oracle line-to-row