A query with a bind variable in an IN clause only allows one value entry. How do you enter in mul (94849)

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.