PL/SQL operator

An operator is a symbol that tells the compiler to perform specific mathematical or logical operations. The PL/SQL language has a wealth of built-in operators, and operators provide the following types:

Arithmetic operator

The following table lists all the arithmetic operators supported by PL/SQL. Assuming the variables Amar10 and variable Back5, then:

View an example of arithmetic operator

Operator description example + add two operands A + B = 15-the first Operand minus the second Operand A-B = 5 * two operands multiply A * B = 50 / divide two operands A / B = 2 * multiplier A * * B = 100000 relational operator

The relational operator compares two expressions or values and returns a Boolean result. The following table lists all the relational operators supported by PL/SQL. Suppose the variable Aban 10 and the variable Bamboo 20, then:

View examples of relational operators

Operator description example = checks whether the values of two operands are equal, and if so, the condition is true. (a = B) the result is false.

! =

~ =

Check whether the values of the two operands are equal, and if the values are not equal, the condition becomes true. (a! = B) the result is true. > check whether the value of the left Operand is greater than that of the right Operand, and if so, the condition is true. (a > B) the result is that false.= checks whether the value of the left Operand is greater than or equal to the value of the right Operand, and if so, the condition is true. (a > = B) the result is false.