TABLE

CREATE OR REPLACE FUNCTION SP_SPITSTR(P_STR IN VARCHAR2,P_DELIMITER IN VARCHAR2)RETURN TBL_SPLIT IS
J INT:=0;
I INT:=1;
LEN INT:=0;
LEN1 INT:=0;
STR VARCHAR2(4000);
STR_SPLIT TBL_SPLIT:=TBL_SPLIT();
BEGIN
 IF P_DELIMITER IS NOT NULL THEN
LEN:=LENGTH(P_STR);
LEN1:=LENGTH(P_DELIMITER);
WHILE J<LEN LOOP
J:=INSTR(P_STR,P_DELIMITER,I);
IF J=0 THEN
J:=LEN;
STR:=SUBSTR(P_STR,I);
STR_SPLIT.EXTEND;
STR_SPLIT(STR_SPLIT.COUNT):=STR;
IF I>=LEN THEN
EXIT;
END IF;
ELSE
STR:=SUBSTR(P_STR,I,J-I);
I:=J+LEN1;
STR_SPLIT:EXTEND;
STR_SPLIT(STR_SPLIT.COUNT):=STR;
END IF;
END LOOP;
ELSE
LEN:=LENGTH(P_STR);
J:=1;
WHILE(P_STR IS NOT NULL AND J<=LEN) LOOP
STR:=SUBSTRB(P_STR,J,1);
STR_SPLIT.EXTEND;
STR_SPLIT(STR_SPLIT.COUNT):=STR;
J:=J+1;
END LOOP;
END IF;
RETURN STR_SPLIT;
END;


CREATE OR REPLACE TYPE "TBL_SPLIT" IS TABLE OF VARCHAR2(4000);



SELECT * FROM TABLE A
WHERE 1=1
AND EXISTS
(SELECT 1 FROM TABLE(SP_SPITSTR(字符串,','))X WHERE A.属性=X.COLUMN_VALUE);