What is mean by view ? and what the use of it ??
sathish
A view is an "Virtual Table". It is not like a simple table, this is an virtual table which contains columns and data from different table ( may be one or more tables) . View does not contain any data directly, it is a set of query that are applied to one or more tables that is stored within the database as object.
"Virtual Table"
Syntax:
CREATE VIEW [View Name]AS[SELECT Statement]