Re: Inserting through a view - forcing certain values into columns

Jeremy wrote:
> In article <55ku75F25p4g8U1_at_mid.individual.net>, Serge Rielau says...

>> WITH CHECK OPTION;
>>

What has been suggested to you will not allow values other than "Y" but will not change an "N" to a "Y".

If you want to override what has been entered use an INSTEAD OF trigger.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org