1. Query

        SELECT ISNULL(MAX('Y'), 'N')
        WHERE EXISTS   (SELECT *
                        FROM TABLE_XXXX ITM
                        JOIN (VALUES
                                 ('0090090102', 1)
                              ,  ('0090090104', 1)
                              ) AS DUAL(KEY_NO, KEY_REV)    ON  DUAL.KEY_NO = ITM.KEY_NO
                                                            AND DUAL.KEY_REV= ITM.KEY_REV

                        WHERE ...
                        )

2. mybatis

        SELECT ISNULL(MAX('N'), 'Y')        AS VAILD_YN
        WHERE EXISTS   (SELECT *
                        FROM TABLE_XXXX ITM
                        JOIN    
                            <foreach collection="p.list" item="item" separator="," open="(VALUES" close=")">
                                (#{item.key_no}, #{item.key_rev})
                            </foreach>
                                AS DUAL(KEY_NO, KEY_REV)    ON  DUAL.KEY_NO = ITM.KEY_NO
                                                            AND DUAL.KEY_REV= ITM.KEY_REV

                        WHERE ...
                        )