SQL & PL/SQL

Hello,

I'd like to turn the string

'7654, 7698, 7782, 7788'

into a list of values that I can use in the WHERE clause of a SELECT statement.

For instance,

select ename
  from emp
 where empno in (somemagicfunction('7654,7698,7782,7788'));

I know how to do it the "hard way". I'm trying to find out if there is an "easy" way.

Thank you for helping.

John.