This figure illustrates views and location transparency. Two servers are shown, a remote sales database and a local HQ database.

• The sales database contains the table scott.emp, with columns empno, ename, job, mgr, hiredate, sal, comm, and deptno.
• The HQ database contains the table jward.dept with the columns deptno and dname.

A client is shown accessing a customized view that contains selected columns from each table (empno, ename, and dname).