Oracle can perform arithmetic in SQL statements.
Arithmetic in SQL statements include addition, subtraction, multiplication, and division.
Arithmetic expressions consist of two operands, numbers or dates, and an arithmetic operator.
'2 * 6' is an example of an expression.
An expression may contain a combination of columns, literal values, and operators.
The four arithmetic operators are:
OperatorDescription
+Addition
-Subtraction
*Multiplication
/Division
SQL>
SQL> SELECT 2 * 6 FROM dual;
2*6
----------
12
SQL>