
Arithmetic operations in SQL( +, , /, * ):
We can do mathematical operations in SQL, please follow the symbols. Here oracle comes with a table called DUAL. which is used mainly for mathematical operations, this table have one row and one column we can say them as virtual. DUAL. is a virtual table which is used for all kinds of Arithmetic operations in SQL.
Arithmetic Operation

Arithmetic Operation Explanation

+

Used for addition in SQL

*

Used for Mulitplication in SQL

/

Used for division in SQL



Used for Subtraction in SQL

Arithmetic Addition in SQL:

Select Salary, (salary+100) ,(salary+1000),(salary+5000) from employees
 select (100+100) from DUAL
Arithmetic subtraction in SQL:

Select Salary, (salary100) ,(salary1000),(5000salary) from employees
 select (100100) from DUAL
Arithmetic Multiplication in SQL:

Select Salary, (salary*100) ,(salary*1000),(salary*5000) from employees
 select (100*100) from DUAL
Arithmetic Division in SQL:

Select Salary, (salary/100) ,(salary/1000),(salary/5000) from employees
 select (100/100) from DUAL
You can do all kinds of Arithmetics combinations in this.
 select (100+Salary)*200 ,salary,(salarycommission_pct) ,( (Salary+commission_pct) /0.100) from employees
