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 >
