Thanks Eli, will do. Regards, - kiru
Kiru Pakkirisamy | webcloudtech.wordpress.com ________________________________ From: Eli Levine <[email protected]> To: [email protected]; Kiru Pakkirisamy <[email protected]> Sent: Wednesday, July 9, 2014 4:56 PM Subject: Re: Updatable view Kiru, only basic equality expressions are supported for creating updateable views. Please file a Jira if you have specific requirements for supporting more complex WHERE clauses in updateable views. Thanks, Eli On Wed, Jul 9, 2014 at 4:48 PM, Kiru Pakkirisamy <[email protected]> wrote: Can't we not use even string functions in the CONSTRAINT of a view ? I get 'table is read only' when I upsert into the view. > > >where (SUBSTR(TO_CHAR(SampleDate), 0,4) = '2014'); > > > >Regards, >- kiru > > > >Kiru Pakkirisamy | webcloudtech.wordpress.com
