oracle - SQL: Parse Comma-delimited string and use as join

Question

How can I parsed a string comma-delimited string from a column in Oracle database and use each one as join to another table

example:

     Table 1                    Table 2

 ID      Name                  ID       Rate
 ---    ------                ----     ------
 1,2,3  FISRT                   1        90
                                2        80      
                                3        70

Would like to extract each ID from Table 1 to join in Table 2, something like

extract(tbl1.ID, i) = tbl2.ID

Thanks in advance.

Answer 1

Based on this answer you can do something like this

select *
from table1 t1 join table2 t2 on ','||t1.id||',' like '%,'||t2.id||',%'

here is a sqlfiddle