Hi All,
If I add this part AND TO_CHAR(A.CAL_DAY_DT, 'YYYYMM') <= TO_CHAR(TRUNC(SYSDATE), 'YYYYMM') Iam getting the follwoing error
cannot create a fast refresh materialized view from a complex query
Results 1 to 6 of 6
Threaded View
|
Click Here to Expand Forum to Full Width |