Example 12-21: Department view with nested employees collection

create view department
as select deptno, dname,
          cast(multiset(select empno, ename, sal 
                        from emp 
                        where emp.deptno = dept.deptno
                        ) as emp_list ) employees
     from dept;