6. QUEL and EQUEL Statements
:
Define View Statement—Define Virtual Tables
:
Example
Share this page
Example
The following example defines a view of employee data that includes name, salary and manager's name:
## range of e is employee
## range of d is dept
## define view empdpt
## (ename = e.name, e.sal, dname = d.name)
## where e.mgr = d.mgr