An operator is a symbol that tells the compiler to perform some specific mathematical or logical operations. PL/SQL language consists of rich in built-in operators. Following types of operators:

Arithmetic Operators
Relational Operators
Comparison Operators
Logical Operators
String operators

Arithmetic Operators:

Following are arithmetic operators supported by PL/SQL. Let’s understand this with an example. Suppose we have two variables a and b with the values 2 and 40 respectively. We will perform the arithmetic operation on both the variables.

Operator Name	Description	Example
+ Addition operator	This operator is used to add two numbers.	a + b i.e.2 + 40 = 42
– Subtraction operator	This operator is used for subtraction of two numbers.	b – a i.e.40 – 2 = 38
* Multiplication operator	This operator is used to perform multiplication operations between two numbers.	a * b i.e.2 * 40 = 80
/ Division operator	This operator is used to divide two numbers. Numerator/Denominator	b / a i.e. 40 / 2 = 20
** Exponential operator	This operator is used to raise power to any number.	ba i.e.402 = 1600

Relational Operators:

Relational operators are used to perform comparison between two expressions or values and provide a Boolean value as a result. Let’s understand this with an example. Suppose we have two variables a and b with the values 2 and 40 respectively.

Operators Name	Description	Example
=equals to	This operator is used to check if the values of two operands (here, a and b) are equal or not, if yes then condition becomes true and returns also true.	a = b is not true.
!=< >~=not equals to	These all three operators perform the same type of task. They check whether the values of operands here a and b are equal or not, if values are not equal then condition becomes true and returns also true.	a != b is true.
>greater than	This operator is used to check whether the value of operand a is greater than the value of operand b. If a is greater than b then condition becomes true and returns also true.	a > b is not true.
<less than	This operator is used to check whether the value of operand a is less than the value of operand b. If a is less than b then condition becomes true and returns also true.	a < b is true.
>=greater equal to	This operator is used to check whether the value of operand a is greater than equal to the value of operand b. If a is greater than equal to b then condition becomes true and returns also true.	a >= b is not true.
<=less than equal to	This operator is used to check whether the value of operand a is less than equal to the value of operand b. If a is less than equal to b then condition becomes true and returns also true.	a <= b is true

Comparison Operators:

Comparison operators are used for comparing one expression to a different one. The result after using these operators are always be TRUE, FALSE or NULL. Comparison operator is mainly in SQL statements.

Operator Name	Description
LIKE	The LIKE operator is used to compare and check value to a pattern and returns TRUE if the value matches otherwise returns FALSE if it does not.
BETWEEN	The BETWEEN operator is used to check whether the value of operand lies in BETWEEN the range or not.
IN	The IN operator is used to check whether the set is present or not.
IS NULL	This operator is used to check for any null or not null value in the table. The IS NULL operator returns the BOOLEAN value TRUE if its operand is NULL or FALSE if it is not NULL.

Logical Operators:

Logical operators are used to perform comparison between two expressions or values and provide a Boolean value as a result. Let’s understand this with an example. Suppose we have two variables a and b with the values 2 and 40 respectively.

Operator name	Description	Example
AND	This is logical AND operator. It lies between two conditions to check both the conditions at the same time. The result becomes true when both the conditions are satisfied otherwise returns false.	a =b AND a > b is false.a =b or AND a < b is false.a !=b AND a < b is true.(both the conditions are not satisfied).
OR	This is logical or operator. It lies between two conditions to check both the conditions at the same time. The result becomes true when at least one condition is satisfied and if both the conditions are not satisfied then returns false.	a =b OR a > b is false.a =b OR a < b is true.a !=b OR a < b is true.(both the conditions are not satisfied).
NOT	A NOT operator performs logical negation on conditions. In other words, if the condition is true, then the output will be false. Similarly, a false condition results in a true output.	NOT a and b is true.