Oracle SQL - Introduction Arithmetic Operators


The SQL language supports four arithmetic operators.

Operator Description
- Subtraction
* Multiplication
/ Division

You can apply arithmetic operators only on NUMBER values; however, there are some exceptions:

  • If you subtract two DATE values, you get the difference between those two dates, expressed in days.
  • You can add a DATE and an INTERVAL value, which results in another date.
  • If you add a DATE and a NUMBER, the number is interpreted as an interval expressed in days.

Alphanumeric Operator: Concatenation

SQL offers only one alphanumeric operator, allowing you to concatenate string expressions: ||.