Loading
Do view contain Data?
12 Answers
No, View does not contain any data. It is just behave like virtual table. When we issue any statement on view, it executes the query to get the rows from the underlying table on which view is been created.
Jignesh KumarPosted Jun 17, 2018, 11:50 PM
yes like mirror, you see it mirror, u got result
RajaGopal GcePosted Jan 21, 2017, 1:13 AM
If normal view than it does not contains the data. and if it is materialized view than it contains the data.
Ashish SrivastavaPosted Jul 8, 2016, 2:26 PM
If normal view than it does not contains the data. and if it is materialsed view than it contains the data.
Keerthi VenkatesanPosted Apr 20, 2016, 5:35 AM
View does not conatains data it fetch the data from the underlying tables.
RAHUL SHUKLAPosted Jul 29, 2015, 3:49 AM
No, view do mot contain data. it contains only the SQL
Statement.
When we try to fetch the data from view , it internally
hits the table and get the data from the table.
Pankaj Kumar ChoudharyPosted Jun 16, 2015, 11:17 AM
no
Debendra DashPosted Apr 21, 2015, 3:16 PM
view is a mirror of database ,it does not contains a data..
patel keyurPosted Dec 18, 2014, 7:24 AM
yes views(SQl) can be consider as virtual table containing data.
Trilochan TripathiPosted Oct 14, 2014, 6:10 AM
No, Views do not have any data for own , it derives data from n number of tables to reduce user Query process, Increase Security..
Santhosh SubramaniamPosted May 28, 2012, 8:39 AM
Views, generally do not contain data of their own. They are basically SQL Commands stored and they return the resultant data based upon the SQL statement, used as the View definition.
However, in Oracle, you have a concept of Materialised Views, which actually hold data, based upon the SQL command associated with the same view.
Ashish DoshiPosted Jun 8, 2011, 7:30 AM
The views do not contain data and store data.
Sapna MalikPosted Jun 6, 2011, 12:10 AM