Oracle Operators is nothing but a character or symbol that represents an action or process. To manipulate individual data items and to return a result Oracle Operators can be used. An operator manipulates individual data items and returns a result. Operators are represented by special characters or by keywords.

What are the operators?

1. In mathematics and sometimes in computer programming, an operator is a character that represents an action, as for example x is an arithmetic operator that represents multiplication. In computer programs, one of the most familiar sets of operators, the Boolean operators, is used to work with true/false values.

How does or operator work in Oracle?

The OR operator is a logical operator that combines Boolean expressions and returns true if one of the expressions is true. The following table shows the results the OR operator between true, false, and a NULL value.