| Esimerkki
laskentaosasto-näkymästä |
|
|
|
|
|
|
|
| CREATE
VIEW Accounting AS |
||||||
| SELECT
dname, loc, empno, ename, job |
||||||
| FROM dept, emp |
||||||
| WHERE
dept.deptno = emp.deptno |
||||||
| AND
dept.deptno = 10; -- 10:
ACCOUNTING-osasto |
||||||
| SELECT
* FROM Accounting; |
||||||
| DROP
VIEW Accounting; |
||||||
