Karthikeyan.M

• Apr 6th, 2005

 

A view is a logical table which makes a  
complex query easy.We can even create 
a complex view by joining two tables.

priya

• May 30th, 2005

 

it is the logical view of the database object

soccer_champ

• Jun 18th, 2005

 

A view is a logical table based on a table, or another view. It can be created using more than one table or view also.

Ramu DBA

• Jul 9th, 2005

 

A view is a named query. It is ?a tailored presentation of the data contained in one or more tables (or other views).? 
 
For SQL, view = a named or derived virtual table 
? For users, view = a table (which in fact does not exist!) 
? View ? a separate copy of an underlying table 
? View = a window into the underlying table 
? Changes can be done from both directions: 
underlying table ? view 
 
Views are created, dropped or granted access to, identical to a table.

hmounir

 Profile Answers by hmounir 

• Dec 27th, 2009

 

A view is also known as stored query, views allow users to see a customized presentation of the data in a single table or even a join between many tables. 

Nagavaram Chalapati

• Aug 14th, 2011

 

View----> View is logical Representation of the physical object
View---> view is physical object acting like logical object
View----> view is one type of security layer architecture
View----> View is protected original of the table

GOURAV MITTAL

• Aug 23rd, 2011

 

A oracle view is only view the table columns which is defined before one or more join tables.A oracle view only read only we can't change in the oracle view.when we apply any query on the actual table then automatically change the oracle change. When we delete the actual table then delete the oracle view.