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 |
How you open and close a cursor variable.Why it is required?
How to check database size in Oracle?
What are the factors causing the reparsing of SQL statements in SGA?
13. Display the second to fifth characters in each client name.
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
when i run my query on yesterday it is fast but today it is slow why?
What is integrity and what is constraint??Explain with example
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What are various joins used while writing SUBQUERIES?
How to resolve name conflicts between variables and columns?
Explain oracle 12c new features for developers?