Updatable view

[Kiru Pakkirisamy]

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