Toad World® Forums

Where Condition

Is there a way to pull in multiple values in a query builder where condition without using the IN operator? Using the drop down takes quite a while to load as there are a large number of values in that particular field/table. I have tried using the IN operator and I can manually enter the items I want but the query still seems to run long.

Yes, stick with the IN operator, but instead of clicking the drop-down arrow, click the dot-dot-dot button to the right of that. Then you can import a list from a file.

In my experience, after selecting the file it will still appear to be blank, but it does bring in the values. I can usually see them after clicking OK in the Query Builder or by clicking the tab to see the SQL code.

Hope that helps.

yes, that is correct. the ellipse will let you load values from a file.