select EMPLOYEES.EMPLOYEE_ID,employees.last_name,employees.department_id, departments.department_id, departments.location_id from employees,departments where employees.department_id=departments.department_id and last_name ='Matos';

select last_name, employees.department_id, department_name from employees, departments where employees.department_id=departments.department_id and last_name='Matos';

select * from user_tablespaces;


SELECT employees.employee_id, departments.department_ID
FROM employees
LEFT JOIN departments
ON employees.employee_id=departments.department_ID
ORDER BY employees.employee_id;


select * from emp_1;

select * from user_mview_logs;


 exec dbms_mview.refresh('EMP_11','C')


CREATE MATERIALIZED VIEW distinct_view
BUILD IMMEDIATE
USING NO INDEX
REFRESH COMPLETE
ON DEMAND
ENABLE QUERY REWRITE
AS
SELECT DISTINCT * FROM emp_1;