To my opinion , you should use trigger to meet your requirement.
"Rama Shankar дµÀ£º
"
> Hi all,
> I have a table like
> create table rs_temp (nm varchar2(10), id number, code number)
>
> and a view like
> create or replace view rs_vw_1 as
> select nm,id from rs_temp where code =1
>
> Is there any way that whenever we insert into the view it insert CODE
> =1 in base table
>
> eg-
>
> insert into rs_vw_1 values ('a',101);
>
> and in base table the record should go as
>
> 'a', 101 , 1
>
> Thanks in advance
> regards
> -rama
Received on Fri Nov 17 2006 - 01:05:35 CST
