In Stored Procedure there is comma seperated string(ID) is Used
How I can Use it in Where condition by Using "IN"

E.g If i get i/p Like '1,2,3,4,5' in variable

I want used that String like this

Select * from Table
Where ID IN(commaseperatedString);

Plz give Solution
Thanks,
Vivek

"Varying elements in IN list" is a search term; here's what Tom Kyte says about it.

reate or replace
PROCEDURE "GET_STUDENT_CITYWISE"
(

IN_CITY_ID IN VARCHAR2, -- Comma sepereted Multiple CITY_ID
OUT_RESULTSET OUT SYS_REFCURSOR
)
AS

BEGIN

BEGIN

OPEN OUT_RESULTSET FOR
SELECT STUDENT_NAME , STUDENT_EMAIL , STUDENT_MOBILE_NO, STUDENT_CITY
FROM USER
WHERE STUDENT_CITY IN(IN_CITY_ID)

END;

-- Handle exception
EXCEPTION WHEN OTHERS THEN
RAISE;

END GET_STUDENT_CITYWISE;

In the Above Student table STUDENT_CITY This Column having Number Datatype.
I want the Result to Filter the Student on the basis of Cities (CommaSeperated)
??

OK. What did you learn on Ask Tom?

t's working now ! Thanks