Re: creating snapshot

From: Frank van Bortel <>
Date: Wed, 02 Jan 2008 09:32:04 +0100
Message-ID: <65b18$477b4bff$524b5c40$> 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

Frank van Bortel

Top-posting is one way to shut me up...
Received on Wed Jan 02 2008 - 02:32:04 CST

Original text of this message