Re: creating snapshot
Date: Wed, 02 Jan 2008 09:32:04 +0100
> 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