| Print Open PDF Version of Online Help

#### Operators Operators are used to combine expression elements to make certain types of comparisons in an expression.
Operator | Function in an Expression
--- | ---
+ | Plus sign for addition.
- | Minus sign for subtraction
* | Multiply sign for multiplication
/ | Divide by sign for division
|| | Character string concatenation
( | Open parenthesis, for grouping operations
) | Close parenthesis, for grouping operations
> | Greater than sign, indicating values higher than the comparison
< | Less than sign, indicating values lower than the comparison
= | Equal sign, indicating the same value
<= | Less than or equal to sign, indicating values the same or lower than the comparison
>= | Greater than or equal to sign, indicating values the same or higher than the comparison
<> | Not equal to, indicating values higher or lower, but not the same
AND | AND connective, indicating intersection with one or more conditions to form a compound condition
OR | OR connective, indicating the union with one or more conditions to form a compound condition
NOT | NOT connective, indicating a condition is not met
, | Comma, used to separate elements in a list

Published August 2022 | Copyright © 2005, 2022, Oracle and/or its affiliates. Legal Notices.