Arithmetic Operators
| Operator | Description |
|---|---|
| + | Adds two operands |
| – | Subtracts second operand from the first |
| * | Multiplies both operands |
| / | Divides numerator by de-numerator |
| ** | Exponentiation operator, raises one operand to the power of other |
Relational Operators
| Operator | Description |
| = | Checks if the values of two operands are equal or not, if yes then condition becomes true. |
| !=<>~= | Checks if the values of two operands are equal or not, if values are not equal then condition becomes true. |
| > | Checks if the value of left operand is greater than the value of right operand, if yes then condition becomes true. |
| < | Checks if the value of left operand is less than the value of right operand, if yes then condition becomes true. |
| >= | Checks if the value of left operand is greater than or equal to the value of right operand, if yes then condition becomes true. |
| <= | Checks if the value of left operand is less than or equal to the value of right operand, if yes then condition becomes true. |
Comparison Operators
| Operator | Description |
|---|---|
| LIKE | The LIKE operator compares a character, string, or CLOB value to a pattern and returns TRUE if the value matches the pattern and FALSE if it does not. |
| BETWEEN | The BETWEEN operator tests whether a value lies in a specified range. x BETWEEN a AND b means that x >= a and x <= b. |
| IN | The IN operator tests set membership. x IN (set) means that x is equal to any member of set. |
| IS NULL | The IS NULL operator returns the BOOLEAN value TRUE if its operand is NULL or FALSE if it is not NULL. Comparisons involving NULL values always yield NULL. |
Logical Operators
| Operator | Description |
|---|---|
| and | Called the logical AND operator. If both the operands are true then condition becomes true. |
| or | Called the logical OR Operator. If any of the two operands is true then condition becomes true. |
| not | Called the logical NOT Operator. Used to reverse the logical state of its operand. If a condition is true then Logical NOT operator will make it false. |