var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Can any one Tell me How to get column from Comma seperated Srting
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
"Varying elements in IN list" is a search term; here's what Tom Kyte says about it.
reate or replace
IN_CITY_ID IN VARCHAR2, -- Comma sepereted Multiple CITY_ID
OUT_RESULTSET OUT SYS_REFCURSOR
OPEN OUT_RESULTSET FOR
SELECT STUDENT_NAME , STUDENT_EMAIL , STUDENT_MOBILE_NO, STUDENT_CITY
WHERE STUDENT_CITY IN(IN_CITY_ID)
-- Handle exception
EXCEPTION WHEN OTHERS THEN
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)
Last edited by Mr.Vivek; 12-06-11 at 10:02.
OK. What did you learn on Ask Tom?