vvgsrk

SHOW MATERIALIZED VIEWS LIKE 'INFARE' IN DATABASE;

vvgsrk

DESCRIBE MATERIALIZED VIEW dm_rmp.infare;

vvgsrk

vvgsrk

-- Cartesian product
SELECT employee_id, first_name || last_name full_name, job_id, department_name
  FROM employees, departments;
  
-- Cartesian product with CROSS JOIN syntax   
SELECT last_name, department_name
  FROM employees CROSS JOIN departments;

vvgsrk

-- Inner Join with the ON Clause
SELECT e.employee_id, e.last_name, e.department_id, d.department_id, d.location_id
  FROM employees e JOIN departments d
    ON (e.department_id = d.department_id);

-- Inner Join with the Equal (=) Operator
SELECT e.employee_id, e.last_name, e.department_id, d.department_id, d.location_id
  FROM employees e, departments d
 WHERE e.department_id = d.department_id;

vvgsrk

-- Joining more than two tables with JOIN and ON keywords
SELECT e.last_name, d.department_name, l.city
  FROM employees e JOIN departments d
    ON (e.department_id = d.department_id)
  JOIN locations l
    ON (d.location_id = l.location_id);

-- Joining more than two tables with equal (=) operator
SELECT e.last_name, d.department_name, l.city
  FROM employees e, departments d, locations l

vvgsrk

SELECT e.last_name, e.salary, j.grade
  FROM employees e, job_grades j
 WHERE e.salary BETWEEN j.lowest_sal AND j.highest_sal;

vvgsrk

SELECT e.last_name, e.department_id, d.department_name
  FROM employees e LEFT OUTER JOIN departments d
    ON (e.department_id = d.department_id);

vvgsrk

SELECT e.last_name, e.department_id, d.department_name
  FROM employees e RIGHT OUTER JOIN departments d
    ON (e.department_id = d.department_id);    

vvgsrk

SELECT e.last_name, e.department_id, d.department_name
  FROM employees e FULL OUTER JOIN departments d
    ON (e.department_id = d.department_id);