Use Operators in Oracle PL / SQL

Oracle PL / SQL Has several built-in / built-in operators, which are:

1. Arithmetic Operator (Arithmetic Operator)
2. Relational Operator
3. Operators Comparison (Comparison Operator)
4. Logical Operator

Arithmetic Operator

Arithmetic operator is an operator used to perform arithmetic / mathematical operations. Below is a table of all kinds of Arithmetic Operators in PL / SQL:

Example: As an exercise example, try typing the PL / SQL program below in your favorite SQL Editor.

BEGIN
 
   dbms_output.put_line('1 + 4 = '|| (1 + 4));
   dbms_output.put_line('7 - 2   = '|| (7 - 2));
   dbms_output.put_line('3 * 10  = '|| (3 * 10));
   dbms_output.put_line('100 / 2 = '|| (100 / 2));

END;
/

Output  if executed

1 + 4 = 5
7 - 2   = 5
3 * 10  = 30
100 / 2 = 50

PL/SQL procedure successfully completed.

Relational Operators

Relational operators are used to compare two expressions or values ​​of two operands. This operator has a value return / return value true or false.

DECLARE

   x number (2) := 21;
   y number (2) := 10;

BEGIN
   
   dbms_output.put_line('nilai x = '||x);
   dbms_output.put_line('nilai y = '||y);
   
   IF (x = y) then
      dbms_output.put_line('Value of x is more than y value');
   ELSE
      dbms_output.put_line('nilai x tidak sama dengan nilai y');
   END IF;

   IF (x < y) then
      dbms_output.put_line('Value of x is not equal to value y');
   ELSE
      dbms_output.put_line('Value of x is more than y value');
   END IF;
   
   IF ( x > y ) THEN
      dbms_output.put_line('Value of x is more than y value');
   ELSE
      dbms_output.put_line('Value of x less than y value');
   END IF;

   
   IF ( x <= y ) THEN
      dbms_output.put_line('Value of x less than or equal to y');
   END IF;

   IF ( x >= y ) THEN
      dbms_output.put_line('Value of x more than or equal to y');
   END IF;
   
   IF ( x <> y ) THEN
      dbms_output.put_line('The value of x is not equal to y');
   ELSE
      dbms_output.put_line('Value x equals y');
   END IF;

END;
/

Output  if executed

nilai x = 21
nilai y = 10
nilai x Not equal to value y
nilai x More than value y
nilai x More than value y
nilai x More than or equal to y
nilai x not equal to y

PL/SQL procedure successfully completed.