Return
-
Title
A query with a bind variable in an IN clause only allows one value entry. How do you enter in mul -
Description
If working with conditions that are checkings lists of values, like an IN clause. How are bind variables used with this?
Sample:
SELECT * FROM Table1 WHERE ColA in (:valuelist);
The prompt box comes up, but multiple values are not accepted (e.g. 123, 1547, 856, 458). It will only take one value (e.g. 123).
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.