Re: MATERIALIZED VIEW FOR PIVOTING TABLE QUERY

Tom wrote:
> I NEED TO CREATE MATERIALIZED VIEW FOR PIVOTING TABLE QUERY ..
>
> REFRESH = FAST
>
> I CAN NOT CREATE IT BECAUSE QUERY IS "TOO COMPLEX".. IS IT??
>
> DOCUMENTATION SAYS THAT MAX AND MIN FUNCTION CAN'T BE USED IN QUERY FOR
> MATERIALIZED VIEW (FAST REFRESHABLE)
>

DON'T shout!

So? Perhaps the docco is right, then?
What do you expect from us?

-- 
Regards,
Frank van Bortel