Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between views and materialized views?
- 5 Answers
- 22239 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / rahul khanke
views : this are the vertiual table.. views dosent stores
the data.. if we update the table then updation is in
actual table..
M view : this are the tables based on one or more tables..
this stores the data.. updation is done then actual
updation is in M. view itself..
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
Inline the values in PL/SQL, what does it mean.?
Does truncate release storage space?
Explain the difference between 'between' & 'and' operators in sql
what is the difference between a having clause and a where clause? : Sql dba
describe mysql connection using mysql binary. : Sql dba
How to start oracle sql developer?
what is the difference between primary key and unique key? : Sql dba
What is sap sql anywhere?
what are the types of join and explain each? : Sql dba
What is the use of double ampersand (&&) in sql queries? Give an example
What are crud methods?
What will you get by the cursor attribute sql%rowcount?
how many ways to get the current time? : Sql dba
how to shut down the server with 'mysqladmin'? : Sql dba
What is the difference between inner join and outer join?
