Do View contain Data ?
Answers were Sorted based on User's Feedback
Answer / nilesh
No , View Do not contain data, instead it contains the SQL
Statement Only.
When we issue statement as select * from <VIEWNAME>
it executes the query to get the rows from the underlying
table on which it is been created.
Is This Answer Correct ? | 24 Yes | 1 No |
Answer / lokanath
View is basically a Stored Query. we can call it as Logical
representaion of table. View Doesnot contain data. But
Materialized view Contains data. Because Materialised view
contains results of a Query.
Is This Answer Correct ? | 13 Yes | 0 No |
Answer / kumar
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.
Is This Answer Correct ? | 13 Yes | 0 No |
Answer / raghu
Views do not contain data...answer#1 is wrong.
Instead materialized views contain data.
..Raghu
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / ab
View do not contain data.
when u query view it featches the data from the underlaying
table on which view is created.
v$ views are created in X$ base tables
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / kumar swamy naidu
physically does not contain any data but logically it contains
data
Is This Answer Correct ? | 0 Yes | 2 No |
What are the uses of synonyms?
What are joins..how many types of joins are there?
29 Answers Amdocs, CSC, TCS,
How to call a stored function in oracle?
Explain oracle data types with examples?
What is the fastest query method to fetch data from the table?
What are the numeric comparison operations?
Why required to run root.sh at the time of installation and what exactly it will do
which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help
How to display employee records who gets more salary than the average salary in the department?
Are truncate and delete commands same? If so why?
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
difference between imlicit cursor and explicit cursor ?