Toad Data Studio 1.1 - User Guide

Set WHERE Conditions

In the Query Builder, you can use a Where condition to filter data returned by a query or to join sets of data.

Note: If you reverse engineer a query that contains a Where clause, it displays in a Global Where clause bubble on the Diagram pane rather than the Where Condition field below the Diagram pane. You can double-click the Global Where Clause bubble in the Diagram pane, or can click to edit it.

To set a Where condition

1. In the Query Builder, add columns to the query. To learn more about the Query Builder, see Build Queries Visually.
2. In the Criteria pane (bottom pane), select the column you want to use to filter data.

3. Select the Where field in the column and click .

   Note: You can also use the Where Condition to add the same column twice to the query.

4. Use the Where Condition editor to create a Where clause. Review the following for additional information:

   Form Page	Description
   Field	Select an operator or predicate to use in this condition.
   Value 1 Type (Value 2 Type)	Select whether the expression is a column or constant. Column—After selecting this option, select the column name. Constant—After selecting this option, enter a value or select a value from the list. If using the IN or NOT IN operator, you can load multiple values from a .txt, Excel, or .csv file. Select Constant. Click in the field to browse to and select a file. If using an Excel file, all values must be in the first column in the first worksheet. If using a .txt file, each value must be on a separate line. After the file is uploaded, the values are automatically added to the Where clause. Click the down arrow to display the loaded values or to deselect some values. Notes: You can also specify a bind variable in this field using ":variable". If you enter a variable, you are prompted to enter a value for the variable when you execute the statement. The Value 2 Type field is only available if you select the Between predicate.
   Formula Page	Description
   Functions	Perform an incremental search or select a function and then select a column on which to perform the function. Note: The date format for functions is any valid date format supported by the database surrounded by single quotes (for example, 'mm/dd/yy').
   Operators	Double-click an operator or predicate to use in this condition.
   Columns and calculated fields	Double-click a column to apply a function or operator against.
   Date Range Page	Description
   Date Range Values	Select a date range to apply to this column. See Set Date Ranges for more information. Note: This tab only displays if you select a column that has a Date data type.

Tips:

• You can use variables in a Where condition. See Using Bind Variables for more information.
• Click Subquery to add a subquery. See Add Subqueries for more information.
• To remove a Where condition, open the Where Condition window and click Remove.

Related Topics

Build Queries Visually 

Add Subqueries

Add Or Conditions