Print      Open PDF Version of Online Help


Previous Topic

Next Topic

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 7/6/2017 Copyright © 2005, 2017, Oracle. All rights reserved. Legal Notices.