What is Clustered Table in Oracle? Difference between Clustered Table and View?

A cluster is a group of tables which share the same data blocks.
Clusters are an optional method of storing table data.
Cluster share common columns and are often used together.
It is a powerful method of storing and organizing data in the dataset into groups or clusters of similar data. Oracle physically stores all rows for each table in the same data blocks.

A view can be considered as a virtual table, It is like a stored query which treats the output of the underlaying query as a table.

Read more here
http://www.geekinterview.com/talk/20450-what-cluster-table-oracle-diff-between.html#post61454

  1 User has rated as useful.

  

Login to rate this answer.

Clustered table store data of multiple table based on common columns.

View is virtual table or which has attached select query.Its not actual table.