Numeric Expressions in Where Clause Oracle Tutorial Example

How to Use Numeric Expressions in Where Clause Oracle Database Tutorial Example

Run Query Editor then copy & paste the below code to use numeric expressions in where clause in Oracle Database Server Tutorial Example

   -- CONNECT AS Any User or HR

   SELECT    LAST_NAME, SALARY, DEPARTMENT_ID, DEPARTMENT_ID/10, ROUND(SALARY/1000)
   FROM      EMPLOYEES
   WHERE     DEPARTMENT_ID/10 = ROUND(SALARY/1000);
   -- be careful to use numeric expressions on indexed column in where clause of large table(s)
   -- is comment in Oracle
   -- in fact it is comment in MSSQL and MySQL as well

How to Use Numeric Expressions in Where Clause Oracle Database Tutorial Example - Result in Query Editor Client Tools

No comments:

Post a Comment

leave your comments here..