Ans:
SELECT Ename, HireDate
FROM Emp
WHERE HireDate >= '01-JAN-1980' AND HireDate <= '31-DEC-1985';
This type of situation can also be achieved by BETWEEN AND
operator. So, you can write the query as below as well.
SELECT Ename, HireDate
FROM Emp
WHERE HireDate BETWEEN '01-JAN-1980' AND '31-DEC-1985';
If you are good with Oracle functions, you can also write the query as below.
SELECT Ename, HireDate
FROM Emp
WHERE to_char(HireDate,'yyyy') BETWEEN '1980' AND '1985';