代码如下:
create materialized view mv_product_orders
build immediate refresh fast on commit
as select
p.pid,p.pname,o.totalqty from Products p,(Select pid,sum(qty) totalqty from Orders group by pid)o where p.pid=o.pid;
代码如下:
create materialized view mv_product_orders
build immediate refresh fast on commit
as select
p.pid,p.pname,o.totalqty from Products p,(Select pid,sum(qty) totalqty from Orders group by pid)o where p.pid=o.pid;