Interested to Buy Any Domain ? << Click Here >> for more details...
what is Materialized view? What is a snapshot? what are the
similarities and differences between Materialized views and
snapshots?
- 2 Answers
- 14336 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mkumar.it
Snapshots and Materialized view are used interchangibly as
both are almost same. However, materialized view is having
additional feature of query rewrite which is not in snapsot.
In this feature, suppose you made any materialized view
using some aggrigate function and you query base table from
sql using same aggrigate funtion, the query will execute on
the materialized view instead of querying base table
provided you have query rewrite priviledge.
| Is This Answer Correct ? | 14 Yes | 2 No |
Answer / its me...
A materialized view is a database object that contains the
results of a query. The FROM clause of the query can name
tables, views, and other materialized views. Collectively
these objects are called master tables .
materialized views allow you to maintain copies of remote
data on your local node.
You can select data from a materialized view as you would
from a table or view.
| Is This Answer Correct ? | 5 Yes | 1 No |
Which Department has MOST NUMBER of employees?
8 Answers IBM, LeadSquared, Mastek,
Explain the truncate in oracle?
How do you rate yourself in oracle and sql server ?
Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
How to view existing locks on the database?
What do you mean by cdb and pdb in oracle 12c?
How to convert times to characters in oracle?
How to load data through external tables?
What is a Segment ?
Oracle
0 Answers ABC, Genpact, HUI, Oracle,
write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000
Oracle General 
