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).
A single variable will only take a single value. If multiple values are needed, specify multiple variables.
Sample:
SELECT * FROM Table1 WHERE ColA in (:val1, :val2, :val3, :val4);
This will prompt for values for each variable.
SELECT * FROM Table1 WHERE ColA in (123, 1547, 856, 458);
Applies to multiple versions of Toad.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy