I have this sql statement.
String sqlQuery ="SELECT "
+"A.SCOPE_ID, A.SCOPE_KEY, A.NAME, A.DESCRIPTION, A.ROLES "
+"FROM IDN_OAUTH2_SCOPE AS A "
+"INNER JOIN AM_API_SCOPES AS B "
+"ON A.SCOPE_ID = B.SCOPE_ID WHERE B.API_ID IN (?)";
and I have this Integer ArrayList
List<Integer> apiIds = new ArrayList<Integer>();
Suppose the array list have some values in it. How can I get the result set for all the apiIds in one database call.