An operator is a character or reserved word that is used to perform some operation. The three principal types of operators used in Query Builder are:
Note: You can also create negating conditions based on these operators.
Comparison operators are used to compare two values. When you insert the operator between a column name and a value in the Conditions panel, Query Builder will compare all items in that column against the value, and return only those rows where the condition statement is true
For example, to return only those rows where the value in the CREDIT_LIMIT column is less than $6,000, use the < (less than) operator:
CREDIT_LIMIT < 6000
Comparison Operator |
Usage |
= |
Equal |
<> |
Not Equal |
< |
Less Than |
<= |
Less Than or Equal To |
> |
Greater Than |
>= |
Greater Than or Equal |
BETWEEN...AND... |
Between two values |
IN (LIST) |
Equal to any member of the following list |
IS NULL |
Is a NULL value. A row without a value in one column is said to contain a NULL value. |
Arithmetic operators are used to perform calculations on numeric and date columns. In handling calculations, Query Builder first evaluates any multiplication or division, then evaluates any addition or subtraction.
To override these precedence rules, place part of the expression in parentheses; Query Builder evaluates expressions in parentheses first.
The Query Builder arithmetic operators are:
Operator |
Usage |
+ |
Addition |
- |
Subtraction |
* |
Multiplication |
/ |
Division |
The logical (also called Boolean) operators are AND, OR, and NOT:
The Icon Bar includes icons for the logical operators. The operator icons are available when the Conditions panel is active, or when the Define Column dialog box is open. You can insert an operator into the text of the condition or defined column by clicking the operator in the Icon Bar.
Adding conditions to a query (Query Builder)
Copyright © 1984, 2005, Oracle. All rights reserved.