Difference between a View and Materialized View in oracle.

Difference between a View and Materialized View in oracle.

View is created joining a single or multiple tables. It is an abstract of the data distributed in different tables. It points to the data of the joined tables rather than the data itself. On the other hand, materialized views have the data itself. This makes it easier and faster to access. It contains pre-computed aggregated information.
What are the kinds of roles in oracle?
What are the kinds of roles in oracle? - Following are the kinds of roles available in oracle: ....
Define primary key and foreign key
Define primary key and foreign key - A column or combination of columns that identify a row of data in a table is Primary Key. A key in a table that identifies records in other table in called a foreign key....
Explain how to DISABLE and ENABLE constraint
Explain how to DISABLE and ENABLE constraint in Oracle - Disable a constraint by using the DISABLE clause......
Post your comment