G.Sreenivasulu

• Mar 29th, 2005

 

A view may also be defined as custom-tailored (data presented to meet requirement) presentation of data from more than one table 
A view is stored inside the database as a select query. 
It does not have any data of its own but it only fetches data from base tables by executing the query written at the time of its creation

Paramjeet singh

• Sep 15th, 2005

 

view is a window to see data from one or more tables.

Raja Sekhar

• Oct 6th, 2005

 

View Is a Customized data representation Of Based on One or more tables .,

Ramesh. S

• Oct 10th, 2005

 

     View is not a stored procedure.it is also a table it will contains the organised fields of one or more than one tables.

manju thanikonda

• Dec 12th, 2005

 

view: Logically represents subset of data from one or more tables

Kanchan

• Apr 20th, 2006

 

Logical representation of data which is created by group of table also called as base tables

Jyothsna

• Apr 26th, 2007

 

A view takes the output of a query and treats it as a table.
 So, view  is a "stored query " and " virtual table"

Sujatars

 Profile Answers by Sujatars 

• Aug 8th, 2007

 

View is? a virtual table based on the result set of a SELECT statement. The fields in the view are fields from one or more real table.

bambino chakma

• Aug 8th, 2007

 

View is a vartual table of logically represented data from one or more no. of table

bambino_chakma

 Profile Answers by bambino_chakma 

• Aug 8th, 2007

 

View is a virtual table of logically represented data from one or more no. of table.

syam sundar

• Aug 18th, 2007

 

View is a layer(not absolute) of the table. It does not really contains any data,it logically contains data. So view is also called as logical table. It hides the names of table and columns and also hides that how it is executing the statement from base table.
Tables on which view is based are called as based tables.
After creating a view, user contact the view then view contact table
If you delete the view then the base table does not effect

patilpravin_1981

 Profile Answers by patilpravin_1981 

• Jan 29th, 2008

 

view is a logical representation of table.

sumanpani

 Profile Answers by sumanpani 

• Sep 16th, 2008

 

View

View is logical table based on one are more table join and named as viewname

View is not stored in database
View is used to perform complex query, View Object,
View support, LOB, varray, Nested Tables
Should have CREATE VIEW or CREATE OR REPLACE VIEW
OWNER of the Schema should have SELECT, UPDATE, DELETE, INSERT

SYNTAX
CREATE OR REPLACE VIEW
FORCE/NOFORCE VIEW V_NAME
Alias/.... AS Subquery;

There are different types of Views - Simple View
and Complex View

thirupathireddy

 Profile Answers by thirupathireddy Questions by thirupathireddy

• Feb 2nd, 2010

 

A view is a subset of tables. View is not stored as physical in database.

ankitagujrati28

 Profile Answers by ankitagujrati28 

• Apr 30th, 2010

 

A view is a mirror image of one or more table. View provides data access privilages.

Suresh Babu Nallamothu

• Nov 8th, 2018

 

A view is a virtual table,Because it doesn't have its own data and it doesn't occupy the database memory.