views.doc

VIEWS A view is a database object, which contains a query in it. Whenever we are executing a select statement repeatedly, instead of specifying the query again and again, we can store the query under an object and execute that object whenever the output is required. That object is called a view. A view is also called as a virtual table, which gives access to a subset of columns from one or more tables. Hence, a view is an object that derives its data from one or more tables. These tables are referred to as the base tables or the underlying tables.