0

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.

0 Answers0