Interested to Buy Any Domain ? << Click Here >> for more details...
Do View contain Data ?
- 10 Answers
- 23731 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 |
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is the difference between truncate & delete command?
what is normalisation?what are its uses?
How to revoke create session privilege from a user in oracle?
What happens to the current transaction if the session is killed?
How to create a new table in your schema?
What is proxy method?
How to create a new user account in oracle?
How to insert a record into a table?
How to retrieve 5th highest sal from emp table?
How to find out what privileges a user currently has in oracle?
WHT ARE THE AGGREATE FUNCTIONS?
Oracle General 
