Interested to Buy Any Domain ? << Click Here >> for more details...
Do View contain Data ?
- 10 Answers
- 23203 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 order of defining local variables and sub procedures/functions?
What is difference between a formal and an actual parameter?
What is Trigger in Oracle?
can a table has a column that has only view data and in other columns we can change data?
ABOUT IDENTITY?
Differentiate between pre-select and pre-query?
What is a synonym? What are its various types?
what is analyze command ? what kind of statistics does it generate?
What is SQL Tuning Advisor in Oracle?
Is oracle a programming language?
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
What do you mean by cdb and pdb in oracle 12c?
Oracle General 
