파라메트'x,x,x' 를 WHERE 조건절에서 IN 으로 사용 IN ,

WHERE IN에 '1,2,3,4' ,로 구분 해서 조회 

SELECT TRIM(REGEXP_SUBSTR('1,2,3', '[^,]+', 1, LEVEL)) AS C1 FROM DUAL
CONNECT BY INSTR('1,2,3', ',', 1, LEVEL - 1) > 0 ;

 

WHERE C1 IN (  
		 SELECT TRIM(REGEXP_SUBSTR('1,2,3', '[^,]+', 1, LEVEL)) AS C1 FROM DUAL
		 CONNECT BY INSTR('1,2,3', ',', 1, LEVEL - 1) > 0 
		 )