CREATE TABLE  "TB_IMPORTDT" 
   (	"AUTOID" NUMBER, 
	"POPULATION" VARCHAR2(6), 
	"DEATH" VARCHAR2(6), 
	"DISEASEID" NUMBER(4)
   )
/

INSERT INTO TB_IMPORTDT VALUES(1,'394849','100',1)
/
INSERT INTO TB_IMPORTDT VALUES(2,'394849','100',2)
/
INSERT INTO TB_IMPORTDT VALUES(3,'394849','100',3)
/
INSERT INTO TB_IMPORTDT VALUES(4,'394849','100',3)
/
INSERT INTO TB_IMPORTDT VALUES(5,'394849','100',1)
/
INSERT INTO TB_IMPORTDT VALUES(6,'394849','100',2)
/
COMMIT;

    AUTOID POPULA DEATH   DISEASEID                                             
---------- ------ ------ ----------                                             
         1 394849 100             1                                             
         2 394849 100             2                                             
         3 394849 100             3                                             
         4 394849 100             3                                             
         5 394849 100             1                                             
         6 394849 100             2                                             

6 rows selected.

MULTIPLE VALUE PASSING into "IN" operator from "MULTI SELECT LIST".

SQL> SELECT * FROM TB_IMPORTDT WHERE DISEASEID IN ('1','2','3');

    AUTOID POPULA DEATH   DISEASEID                                             
---------- ------ ------ ----------                                             
         1 394849 100             1                                             
         2 394849 100             2                                             
         3 394849 100             3                                             
         4 394849 100             3                                             
         5 394849 100             1                                             
         6 394849 100             2                                             

6 rows selected.

 SELECT * FROM TB_IMPORTDT WHERE DISEASEID IN (:P_DISEASELIST)