Suppose I have a string '1,2,3'

I want to tokenize the string and convert each of the tokens into NUMBER. So the above string will be tokenized into :

```
        1      NUMBER
        2      NUMBER
        3      NUMBER

```

The final intention is to use them in a query as part of IN clause as below :

select \* from sample where type in (1,2,3) ;

How can I achieve this ? One important point here is the string can have different number of tokens in different situations. So it can be either '1,2,3' or '1,2' or '1,2,3,4' or even '1'.

Please help me out guys.

Thanks in advance.