when we select the data from a view, are we selecting from the base table?
Thanks.
Printable View
when we select the data from a view, are we selecting from the base table?
Thanks.
Views
Views are customized presentations of data in one or more tables or other views. A view can also be considered a stored query. Views do not actually contain data. Rather, they derive their data from the tables on which they are based, referred to as the base tables of the views.
http://tahiti.oracle.com Concepts Guide, look up the definition of a view