Basic HTML version of Foils prepared 7 October 97

Foil 24 Define a View in Oracle - An Example

From Untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox
Suppose we'd like to create a view (virtual table) called staff_info_table which has all the personal information of NPAC staff.
This view will use the base table person_info_table with the position column has only staff related value

© 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