Re: creating snapshot
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 02 Jan 2008 09:32:04 +0100
Message-ID: <65b18$477b4bff$524b5c40$23540@cache6.tilbu1.nb.home.nl>
Date: Wed, 02 Jan 2008 09:32:04 +0100
Message-ID: <65b18$477b4bff$524b5c40$23540@cache6.tilbu1.nb.home.nl>
amitabh.mehra_at_gmail.com wrote:
>
> My requirement is: If status is 'new' then the snapshot should have
> null as the value else it should have whatever value is there. For
> that I was trying to use the decode. Can this be done?
Look up 'with rowid' on the create materialized view statement options
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Wed Jan 02 2008 - 02:32:04 CST