代码如下:
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;
http://www.itpub.net/forum.php?mod=viewthread&tid=1790561
http://zhidao.baidu.com/link?url=MfahyQfoN4RKCkURXPq0jXcrVzT0Vy47CTbq3ApbNwd1Mtc7Rh5M9sqAYEpaqfewMpQRKlYnCJzvWSb9DVNtna