View & Its Uses

View & Its Uses

A view is a virtual table (created dynamically), that does not physically exist. Rather, it is created by a query joining one or more tables.
OR
A view is a virtual table that consists of columns from one or more tables. Though it is similar to a table, it is stored in the database. It is a query (they dont hold data)stored as an object. Hence, a view is an object that derives its data from one or more tables. These tables are referred to as base or underlying tables.

use - can be used to breakup complex sql stmnts in to easier handelled shorter queries