Re: How to consolidate code for WHERE column IN (prm,....,prn-n)??
From: <zlatko_sirotic_at_my-deja.com>
Date: Tue, 23 Jan 2001 15:49:21 GMT
Message-ID: <94k95t$van$1_at_nnrp1.deja.com>
Date: Tue, 23 Jan 2001 15:49:21 GMT
Message-ID: <94k95t$van$1_at_nnrp1.deja.com>
You can try this solution, without dynamic SQL:
DECLARE
/* Variable myids must begin and end with
separator (in this case ",") */
v_myids VARCHAR2
(32000) := ',204,201,200,253,224,';
BEGIN
FOR emp_rec IN (
SELECT *
FROM emp
WHERE INSTR (v_myids, ',' | | empno | | ',') >
0) -- separator is ","
LOOP
DBMS_OUTPUT.PUT_LINE (emp_rec.empno);
END LOOP;
END;
But, this solution can have performance problems.
Regards
Sent via Deja.com
http://www.deja.com/
Received on Tue Jan 23 2001 - 16:49:21 CET