CREATE OR REPLACE VIEW dept_emp_v AS
SELECT emp_no, dept_no
  FROM dept_emp
 WHERE SYSDATE() BETWEEN from_date AND to_date;

SELECT *
  FROM dept_emp_v;