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
View - customized presentation of the data in one or more tables
Views do not actually contain or store data
They derive their data from the tables on which they are based, referred to as the base table
Like tables, views can be queried, updated, inserted into, and deleted from, but with some restrictions
All operations performed on a view actually affect the base tables of the view

© 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