Guide to Oracle SQL (University at Buffalo Version)
Creating Other Schema Objects
Most database end-users will never use SQL to query the database. The SQL developers create
VIEWS that the end-user can execute to get the data they need.
A view stores an SQL query that is executed whenever you refer to the view. This is a convenient way to get the desired data because it is easier to run a query stored in a view than to types a query from scratch. Using a view also allows you to provide access to just the data that particular user needs - and nothing else. The
view creates the table structure for a result set and then fills in the data when the
view is invoked.
You call a
view using the