I'm using Oracle 10g XE. I've looked all over for this but I can't seem to find the exact answer I'm looking for. I've seen things that "work" like this: TRUNC(sysdate) - TRUNC(emp_hiredate) But it doesn't work in a way that I understand or in a way I can format the way I want. The question goes like this:Write a query that will list the employee number, employee last name, employee first name, employee hire date, a computation of the number of years since the employee was hired up to the date you run the query and the query run date. List the computed number of years as YEARS EMPLOYED and the query run date as QUERY DATE. I don't understand how to do this. So far, this is what I have.SELECT emp_num, emp_lname, emp_fname, emp_hiredateFROM employee I know it isn't much, but I just don't understand how to do this computation. I remember my instructor saying something about needing to divide by 365 to get the correct answer, but other than that I am clueless.Any help would be greatly appreciated.