Interested to Buy Any Domain ? << Click Here >> for more details...
Do View contain Data ?
- 10 Answers
- 23447 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 |
What is the difference between translate and replace in oracle?
What are joins..how many types of joins are there?
29 Answers Amdocs, CSC, TCS,
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Which environment variables are absolutely critical in order to run the OUI?
13. Display the second to fifth characters in each client name.
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to list all tables in your schema?
master table and child table performances and comparisons in Oracle ?
What is a database table in oracle?
Can a primary key contain more than one columns?
What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
Explain what are synonyms used for?
Oracle General 
