default column value in view while inserting.

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 - 00:26:44 CST