I have scenario where I need to join 5 tables to get certain columns in the select statement.
Instead I thought of using Materialized View which will contain the columns of the base tables.
Which are below:-
CustId, ProductName, OrderNo, PriceDetail, DiscountValue
I need to add the above columns in MV where there columns are coming from 5 different tables .
So that when we insert/update the base tables, it will reflect in MV as well.
Hence how to create a MV with these columns? whether we need to create as a table or a View?