Arithmetic Expressions in Oracle Select Clause

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
   

How To Use Arithmetic Expressions in Oracle Database Tutorial Example - Result in Query Editor Client Tools

No comments:

Post a Comment

leave your comments here..