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 can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10
What is proxy method?
What is a initialization parameter file in oracle?
12. Display the client name in upper case only and in lower case only.
When do I need to use a semicolon vs a slash in oracle sql?
What are the ways tablespaces can be managed and how do they differ?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What are the limitations oracle database 10g xe?
State the various uses of dbcc command?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
How do I use os authentication with weblogic jdriver for oracle and connection pools?