刷新物化视图和查看子类四级分类

exec dbms_refresh.refresh('mv_goods_list')
( SELECT C2.CATGROUP_ID_CHILD G4
FROM xiu_goods.CATGRPREL C
LEFT JOIN xiu_goods.CATGRPREL C1
ON C1.CATGROUP_ID_PARENT = C.CATGROUP_ID_CHILD
AND C1.CATALOG_ID = C.CATALOG_ID
LEFT JOIN xiu_goods.CATGRPREL C2
ON c2.CATGROUP_ID_PARENT = C1.CATGROUP_ID_CHILD
AND C2.CATALOG_ID = C1.CATALOG_ID
WHERE C.CATALOG_ID = 10001
AND C.CATGROUP_ID_PARENT = 14715 --查询四级分类
AND C2.CATGROUP_ID_CHILD IS NOT NULL)
ORDER BY CES.LASTUPDATE DESC
--查询 父类下所有四级分类
SELECT C2.CATGROUP_ID_CHILD G4
FROM xiu_goods.CATGRPREL C
LEFT JOIN xiu_goods.CATGRPREL C1
ON C1.CATGROUP_ID_PARENT = C.CATGROUP_ID_CHILD
AND C1.CATALOG_ID = C.CATALOG_ID
LEFT JOIN xiu_goods.CATGRPREL C2
ON c2.CATGROUP_ID_PARENT = C1.CATGROUP_ID_CHILD
AND C2.CATALOG_ID = C1.CATALOG_ID
WHERE C.CATALOG_ID = 10001
AND C.CATGROUP_ID_CHILD = 14715
AND C2.CATGROUP_ID_CHILD IS NOT NULL