Interested to Buy Any Domain ? << Click Here >> for more details...
Do View contain Data ?
- 10 Answers
- 23522 Views
- I also Faced
- E-Mail Answers
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 to create tables for odbc connection testing?
What is Reduced List of Values?
There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep
How to connect to the server with user account: sys?
How to update a table row with a record?
How to remove a row in a database table?
"primary key=unique+null" is equal,reson?not,reason?
What is literal?
What are the differences between date and timestamp in oracle?
What is a subquery?
what is the syntax of DROP command?
How to set up autotrace for a user account?
Oracle General 
