Basic HTML version of Foils prepared 7 October 97

Foil 21 Major Schema Objects in Oracle -IV- View

From Untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox
1 View - customized presentation of the data in one or more tables
2 Views do not actually contain or store data
3 They derive their data from the tables on which they are based, referred to as the base table
4 Like tables, views can be queried, updated, inserted into, and deleted from, but with some restrictions
5 All operations performed on a view actually affect the base tables of the view
in Table To:

© Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Tue Jan 27 1998