Concatenation in Oracle SELECT Clause Example

Concatenation in SELECT Clause Oracle Database Tutorial Example

Run Query Editor then copy & paste the below code to use concatenation in SELECT clause in Oracle Database Server Tutorial Example

   -- CONNECT AS Any User or HR

   SELECT  LAST_NAME || ' has worked ' || ROUND(SYSDATE - HIRE_DATE)
           || ' dsys.' AS " Employee Status"
   FROM    EMPLOYEES;

      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

Concatenation in SELECT Clause Oracle Database Tutorial Example - Result in Query Editor Client Tools