Developers like views…they can simplify things and hide (protect us from) underlying complexity.
For example, would you rather write the query -
SELECT
ename,
department_name
FROM
emp_vw
or
SELECT
e.ename,
d.dname
FROM
emp e,
dept d
WHERE
e.deptno = d.deptno;
It’s a rhetorical question so please don’t say “I prefer the second”…otherwise there’s no point [...]
