How To Use Arithmetic Expressions in Oracle Database Tutorial Example
Run Query Editor then copy & paste the below code to use Arithmetic Expressions in SELECT clause in a table in Oracle Database Server Tutorial Example
-- CONNECT AS HR
SELECT LAST_NAME,
SALARY "Old Salary",
(SALARY*10/100) "Increment",
(SALARY+SALARY*10/100) "Revised Salary"
FROM EMPLOYEES;
-- is comment in Oracle
-- in fact it is comment in MSSQL and MySQL as well

No comments:
Post a Comment
leave your comments here..