Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Query Select

 

Performing Arithmetic

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>