Re: Materialized View - Performance
From: ddf <oratune_at_msn.com>
Date: Fri, 27 Feb 2009 07:02:02 -0800 (PST)
Message-ID: <e992b6a6-67f8-4c4e-8ab2-4002ea211e27_at_j12g2000vbl.googlegroups.com>
On Feb 4, 10:01 am, Joel <johow..._at_gmail.com> wrote:
> Did you ever find out if the with clause in MV is possible?
>
> Thanks
>
>
>
> > > Can i implement WITH Clause here also, similar to what i have done in
> > > 2nd scenario solution ?- Hide quoted text -
>
> - Show quoted text -
Date: Fri, 27 Feb 2009 07:02:02 -0800 (PST)
Message-ID: <e992b6a6-67f8-4c4e-8ab2-4002ea211e27_at_j12g2000vbl.googlegroups.com>
On Feb 4, 10:01 am, Joel <johow..._at_gmail.com> wrote:
> Did you ever find out if the with clause in MV is possible?
>
> Thanks
>
>
>
> > > Can i implement WITH Clause here also, similar to what i have done in
> > > 2nd scenario solution ?- Hide quoted text -
>
> - Show quoted text -
Yes, it is valid syntax since 9.2.0.X.
David Fitzjarrell Received on Fri Feb 27 2009 - 09:02:02 CST