I created a definitions table,T\_DEFINITION
This table has 2 columns: category\_id and included\_service\_list.
/\*There are many columns which are working like INCLUDED\_SERVICE\_LIST logic, so I wrote one of them to make the question simple\*/
Sample of table is:

```
CATEGORY_ID    INCLUDED_SERVICE_LIST
18             24,37,86,102,125,144,226,285
24             12,25,33,49,52,55,58,63,69,70,80,90,107

```

and values go on like this.

In my select statement; I want to query INCLUDED\_SERVICE\_LIST column:

```
SELECT * 
FROM T_TRANSACTION A,T_DEFINITION B
WHERE A.SERVICE_ID IN (string.split(B.INCLUDED_SERVICE_LIST))             

```

I need to split the string in the INCLUDED\_SERVICE\_LIST column and use it in select statement.
`string.split` is my custom split function, which returns a table of varchar2.

But I do not know how to select values from the output table of varchar2.
Could you help me?

Thanks