view and materialized view in oracle. There are any references about view and materialized view in oracle in here. you can look below.