top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Oracle: How display the names of employees who are working in the company for the past 5 years?

0 votes
4,222 views
Oracle: How display the names of employees who are working in the company for the past 5 years?
posted Jun 12, 2015 by Kunal Kapoor

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button
Will this logic be sufficient for leap year

1 Answer

0 votes

Select employeename from employee where sysdate-hiredate>5*365;

answer Jun 17, 2015 by Manikandan J
...