Display those employee whose first 2 characters from hiredate -last 2 characters of salary?

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 1187
SQL>select ename,SUBSTR(hiredate,1,2)||ENAME||substr(sal,-2,2) from emp

Comments or Responses

Login to post response