Table of Contents
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. |