Performing Arithmetic : Arithmetic « Query Select « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Query Select
3. Arithmetic

1. Oracle can perform arithmetic in SQL statements.
2. Arithmetic in SQL statements include addition, subtraction, multiplication, and division.
3. Arithmetic expressions consist of two operands, numbers or dates, and an arithmetic operator.
4. '2 * 6' is an example of an expression.
5. An expression may contain a combination of columns, literal values, and operators.

The four arithmetic operators are:

SQL>
SQL> SELECT 2 * 6 FROM dual;

       2*6
----------
        12

SQL>